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 Posted / 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 |
Post New Answer View All Answers
Why is partition used in sql?
Explain unique key in sql.
Explain about various levels of constraint.
Do prepared statements prevent sql injection?
What is the difference between partition and index?
What is the mutating table and constraining table?
What type of database is cloud sql?
Is subquery faster than join?
How do I restart sql?
What is the difference between in and between in sql?
What are the operators used in select statements?
What are inner outer left and right joins in sql?
What do you think about pl/sql?
what is a constraint? : Sql dba
What is a primary key called that is made up of more than one field?