Dropping Indexes vs. Disabling Indexes?
976640Mar 13 2013 — edited Mar 15 2013Hi There,
I need to know the basic internal differences between Dropping Indexes and Disabling Indexes?
Also,
1. What happens when we disable indexes?
2. When we disable indexes on table, whether select query executes full table scan?
Suppose before disabling the indexes, inserted two records with id 1 and 2.
After disabling the indexes, we insert one more record with id 3. Now when query select * from myTable where id in (1, 2, 3);
Will this issue full table scan?
3. Is there any benefit of doing disable over dropping of indexes?
Thanks,
Arfeen.