Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6463 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 partition in sql query?
what is self join and what is the requirement of self join? : Sql dba
What are the benefits of stored procedures?
Is coalesce faster than isnull?
How do I delete a trigger?
What is a heap in sql?
What is dialect in sql?
What is the difference between left and left outer join?
What is the requirement of self-join?
Can a select statement fire a trigger?
Where is sql database stored?
What is database sql?
what is innodb? : Sql dba
What is t sql used for?
how many columns can be used for creating index? : Sql dba
