Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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?

Question Posted / guest


There is a table, In one column it has implemented a index, but the index is disturbed by the regu..

Answer / 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

More SQL PLSQL Interview Questions

What are secondary keys?

0 Answers  

What are the types of index in sql?

0 Answers  

How do you declare a user-defined exception?

0 Answers  

Explain exception handling in pl/sql?

0 Answers  

What is sql profiling in oracle?

0 Answers  




How do I partition in sql?

0 Answers  

how is exception handling handled in mysql? : Sql dba

0 Answers  

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

How do sql triggers work?

0 Answers  

Differentiate between sga and pga.

0 Answers  

What is varchar example?

0 Answers  

How to select unique records from a table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories