CREATE INDEX IF NOT EXISTS IDX_CARD_DETAILS ON CARD_DETAILS (CARD_ID ASC);CREATE UNIQUE INDEX  IF NOT EXISTS IDX_PROPERTIES ON PROPERTIES (OFFICE_ID ASC, KEY ASC);CREATE INDEX  IF NOT EXISTS IDX_X_ENT ON X_ENTITLEMENTS(ID);CREATE INDEX  IF NOT EXISTS IDX_ME_CARD_ALLOTMENT_MONTH ON MEMBER_ENTITLEMENT(ALLOTMENT_MONTH,CARD_NO);CREATE INDEX  IF NOT EXISTS IDX_ORDER_HEADER ON ORDER_HEADER (ID ASC);CREATE INDEX  IF NOT EXISTS IDX_ORDER_HEADER_DATE ON ORDER_HEADER (ORDER_DATE ASC);CREATE INDEX  IF NOT EXISTS IDX_ORDER_TRAILER ON ORDER_TRAILER (ORDER_ID ASC);CREATE INDEX  IF NOT EXISTS IDX_PRODUCT_DETAILS ON PRODUCT_DETAILS (ID ASC);CREATE UNIQUE INDEX  IF NOT EXISTS IDX_STOCK_INVENTORY2 ON Stock_Inventory (txn_date ASC, product_id ASC, ALLOTMENT_MONTH ASC, OFFICE_ID ASC);CREATE UNIQUE INDEX  IF NOT EXISTS IDX_ORDER_HEADER2 ON ORDER_HEADER (ID ASC);CREATE INDEX IF NOT EXISTS IDX_MEMBER_ENTITLEMENT ON MEMBER_ENTITLEMENT (ID ASC);