Drop Index or Disable index?
Plat for is Oracle Standard Edition 11.2.0.4 on Windows 2008 Server R2.
I plan to delete 20% of rows in a table. About 2 million.
I am going to delete 10,000 rows at a time.
I'm anxious about dropping the indexes. Should I just disable and rebuild them?
Is there a recommended way to disable and rebuild indexes <<actually it's clear in documentation.. don't know why I have to ask it.>>
1)
if index belongs to primary key.
ALTER TABLE DISABLE CONSTRAINT name KEEP INDEX;
And if index doesn't belong to primary but only to normal field.
ALTER INDEX DISABLE..
2)
Or just drop and recreate indexes using get_ddl?