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 do you mean by stored procedures?

0 Answers  

what is data manipulation language? : Sql dba

0 Answers  

what are the differences between char and nchar? : Sql dba

0 Answers  

Why select is used in sql?

0 Answers  

Differentiate between % rowtype and type record.

0 Answers  

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

what is definer rights invoke rights?

1 Answers  

Is sql database free?

0 Answers  

Is primary key clustered index?

0 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

What is an alias command?

0 Answers  

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

16 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories