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?
- 1 Answers
- 6098 Views
- Cognizant, I also Faced
- E-Mail Answers
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
What is the maximum rows in csv?
What is the current version of postgresql?
Can we join same table in sql?
Explain what is a subquery ?
What is cascade in sql?
How do I run sql?
What is difference between joins and union?
What is sql keyword?
What is difference between function and trigger?
What is hibernate and its relation to sql?
What is trigger in flip flop?
what is foreign key? : Sql dba
What is partition by in sql?
what is try_catch block in procedure
How insert into statements in sql?
