Re: Disable single index instead of all indexes

[Ra Nala]

Yes Sir Rick James,

I am loading my data from OLTP to temp aread(i.e. staging) area and finally to Datamart table.

example: Table A --> table B(staging area) --> Table C (data mart).

staging area is always cleaning and loading operations data.

Still i want to turn of index belore data load into my Datamart table , once data loaded process is completed want to rebuild index.

still my problem is how can i check, is index is disabled or not.
When i googled got the answer is : SHOW INDEX tablename

but in the result what is identification is disabled ?/ still i wasn't able to see info exactly