title: getting error the operation 'alter table add index' is not supported with memory optimized tables in sql server
body: <p>I am working with sql server, I need to add index for the column, when adding index it gives me error <code>the operation 'alter table add index' is not supported with memory optimized tables.</code>, can anyone please tell me how can i resolve this issue ? Here is my table structure</p>
  
  <pre><code>CREATE TABLE "tb_Episode" (
      "ID" INT NOT NULL,
      "EpDataID" INT NULL DEFAULT NULL,
      "UploadID" INT NULL DEFAULT NULL,
      "CustID" INT NULL DEFAULT NULL,
      "BranchID" INT NULL DEFAULT NULL,
      "Branch" VARCHAR(20) NULL DEFAULT NULL,
      "LastName" VARCHAR(19) NULL DEFAULT NULL,
      "FirstName" VARCHAR(12) NULL DEFAULT NULL,
      "Middle" VARCHAR(1) NULL DEFAULT NULL,
      "MRN" INT NULL DEFAULT NULL,
      "MedicareNbr" VARCHAR(10) NULL DEFAULT NULL,
      "EpStart" DATE NULL DEFAULT NULL,
      "EpEnd" DATE NULL DEFAULT NULL,
      "SOCDate" DATE NULL DEFAULT NULL,
      "DOB" DATE NULL DEFAULT NULL,
      "SysBranch" VARCHAR(24) NULL DEFAULT NULL,
      "PhyLastName" VARCHAR(24) NULL DEFAULT NULL,
      "PhyFirstName" VARCHAR(13) NULL DEFAULT NULL,
      "SNVisits" INT NULL DEFAULT NULL,
      "PTVisits" INT NULL DEFAULT NULL,
      "OTVisits" INT NULL DEFAULT NULL,
      "HHAVisits" INT NULL DEFAULT NULL,
      "MSWVisits" INT NULL DEFAULT NULL,
      "STVisits" INT NULL DEFAULT NULL,
      PRIMARY KEY ("ID")
  )
  ;
  </code></pre>