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 does the hierarchical profiler does?

0 Answers  

Why do we use sql constraints? Which constraints we can use while creating database in sql?

0 Answers  

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

What is a table partition?

0 Answers  

what is subquery? : Sql dba

0 Answers  




What is oracle pl sql developer?

0 Answers  

How does pl sql work?

0 Answers  

How can a function retun more than one value in oracle with proper example?

0 Answers  

How do you modify a trigger?

0 Answers  

Compare sql & pl/sql

0 Answers  

What is trigger types in sql?

0 Answers  

What is rtm stands for?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories