• In progress

    • Flipkart Indexes Modification:

    Owned by Piyush Kumar
    Last updated: Aug 03, 2023
    1 min read

    1. proxy_flipkart_v3line_item:

      1. drop index orderId on proxy_flipkart_v3line_item; (Not used)

    2. proxy_flipkart_v3manifest:

      1. drop index ManifestId on proxy_flipkart_v3manifest; (Duplicate)

    3. order_notifications:

      1. create INDEX INDEX_VENDOR_ID_ORDER_TYPE_IS_SYNCED_VERSION_CREATED_AT_LAST_SYNC_TRY_TIME on order_notifications(vendor_id, order_type, is_synced, version, created_at, last_sync_try_time);

      2. drop index INDEX_VENDOR_ID_ORDER_TYPE_IS_SYNCED_VERSION_CREATED_AT on order_notifications;

    4. proxy_flipkart_v3order:

      1. create INDEX statusProcessingTimeClientLocationLastTriedTime on proxy_flipkart_v3order(status, start_processing_time, client_id, location_code, last_tried_time);

      2. drop index statusProcessingTimeClientLocation on proxy_flipkart_v3order;

    5. proxy_push_order:

      1. ALTER TABLE proxy_push_order ADD CONSTRAINT UK_SHIPMENT_ID_VENDOR_ID UNIQUE(shipment_id, vendor_id);

      2. ALTER TABLE proxy_push_order DROP CONSTRAINT UKoi5t2v25wjrvoexx8i1bqdne4;

      3. drop INDEX getOrders from proxy_push_order;

    6. return_notifications:

      1. create INDEX INDEX_VENDOR_ID_IS_SYNCED_VERSION_CREATED_AT_LAST_SYNC_TRY_TIME on return_notifications(vendor_id,is_synced,version,created_at,last_sync_try_time);

      2. drop INDEX INDEX_VENDOR_ID_IS_SYNCED_VERSION_CREATED_AT on return_notifications;

    7. proxy_return_order:

      1. create INDEX INDEX_ORDER_ITEM_ID_VENDOR_ID_RETURN_ID_PROXY_RETURN_ORDER_ID on proxy_return_order(order_item_id,vendor_id,return_id,proxy_return_order_id);

      2. drop INDEX fetchReturnOrders on proxy_return_order;