Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How do you use a while loop in pl sql?

0 Answers  

What is sql*loader and what is it used for?

0 Answers  

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

How can I get the number of records affected by a stored procedure?

0 Answers  

What is pl/sql and what is it used for?

4 Answers  

What can I use instead of union in sql?

0 Answers  

What is coalesce sql?

0 Answers  

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

What is the sql*loader? : aql loader

0 Answers  

What is dynamic sql in pl sql?

0 Answers  

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

How can you load multi line records? : aql loader

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories