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

What is a temp table?

0 Answers  

Cite the differences between execution of triggers and stored procedures?

0 Answers  

How do I edit a trigger in sql developer?

0 Answers  

Mention what are different methods to trace the pl/sql code?

0 Answers  

Is sqlite thread safe?

0 Answers  

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

Do we need to create index on primary key?

0 Answers  

how to saw triggers output in pl/sql database?

1 Answers  

What do you mean by field in sql?

0 Answers  

what are the type of locks ? : Sql dba

0 Answers  

What will you get by the cursor attribute sql%notfound?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories