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
- 6620 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 to write date and time literals? : Sql dba
What is sql used for?
What are the types pl/sql code blocks?
How to use transactions efficiently : transact sql
How do I run a pl sql program?
what are the advantages and disadvantages of views in a database? : Sql dba
Which data type is a composite type?
Why query optimization is needed?
Is there a 64 bit version of ssms?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Is pl sql useful?
How to know the last executed procedure?
Why do we need cursor in pl sql?
How does sql profiler work?
does sql support programming? : Sql dba
