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
- 6483 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
who introduced sql?
Explain what is dbms?
How do I run pl sql in sql developer?
Why do we use cursors?
What is the difference between microsoft access and sql server?
what is a tablespace? : Sql dba
can sql servers linked to other servers like oracle? : Sql dba
How is a PL/SQL code compiled?
Explain the methods used to protect source code of pl/sql.
What is the use of sqlerrd 3?
How do I create a memory optimized filegroup?
how to use case expression? : Sql dba
State few characteristics of pl/sql?
Is it possible to sort a column using a column alias?
How do I view tables in sql developer?
