There is a table, In one column it has implemented a index,
but the index is disturbed by the regular dml statements..
but still we need to keep the index. how it is possible?
Answer / a.v.r.murthy
GENERALLY INDEX WILL BE CREATED ON LESS NUMBER OF DML
OPERATION COLUMNS.
EVENTHOUGH IF WE WANT PERFORM BETTER THEN BEFORE INSERTING
DATA INTO THE COLUMN WE HAVE TO DISABLE THE INDEX i.e
ALTER INDEX IDX_NAME UNUSABLE;
Is This Answer Correct ? | 7 Yes | 0 No |
What does the hierarchical profiler does?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
what is the difference between cursor FETCH and FOR LOOP ?
3 Answers CG-VAK, Tech Mahindra,
What is a table partition?
what is subquery? : Sql dba
What is oracle pl sql developer?
How does pl sql work?
How can a function retun more than one value in oracle with proper example?
How do you modify a trigger?
Compare sql & pl/sql
What is trigger types in sql?
What is rtm stands for?