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 is informix sql?

0 Answers  

Types of joins?

4 Answers   Microsoft,

Explain what is a field in a database and record in a database?

0 Answers  

what is meant by urlencode and urldocode? : Sql dba

0 Answers  

How do I save a stored procedure?

0 Answers  

what are tables and fields? : Sql dba

0 Answers  

How do you use join?

0 Answers  

What is the difference between a primary key and a unique key?

0 Answers  

four procedures is are there should i write their in a package

2 Answers  

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

How will we see framework of a table?

2 Answers   Accenture,

difference between pl/sql table and normal pl/sql table

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories