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
- 6547 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 oracle database ? : Sql dba
What does inner join mean?
What is the purpose of cursors in pl/sql?
What are the different ways to optimize a sql query?
Is sql a case sensitive language?
Why is pl sql used?
How do you write an index?
What are actual parameters and formal parameters?
What is the purpose of using pl/sql?
Explain the purpose of %type and %rowtype data types with the example?
What are variables in pl sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
Is oracel sql developer written in java?
What is a call statement? Explain with an example.
Write the alter statement to enable all the triggers on the t.students table.
