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
- 6570 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
How many tables can a sql database have?
What is difference between mysql and postgresql?
What is a variable in sql?
What is audit logout in sql profiler?
What is the purpose of my sql?
What does count (*) do in sql?
How do I access sql anywhere database?
What is the purpose of primary key?
Which is faster joins or subqueries?
What is the difference between joins?
What is a Mapplet?
Explain the the update statement in sql?
Why is nosql good?
what is single byte over head in oracle..?
What are the types of queries in sql?
