Flipkart Indexes Modification:

proxy_flipkart_v3line_item:

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

proxy_flipkart_v3manifest:

1. drop index ManifestId on proxy_flipkart_v3manifest; (Duplicate)

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;

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;

proxy_push_order:

1. create INDEX INDEX_STATUS_VENDOR_ID_LOCATION_ID_CREATED_AT on proxy_push_order(status, vendor_id,location_id,created_at);

2. drop INDEX fetchOrders from proxy_push_order;

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;

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;