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 can I change database name in sql?

0 Answers  

How to fix oracle error ora-00942: table or view does not exist

0 Answers  

What is audit logout in sql profiler?

0 Answers  

Is pl sql different from sql?

0 Answers  

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

What is the purpose of the primary key?

0 Answers  

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

what is sql in mysql? : Sql dba

0 Answers  

What is delimiter sql?

0 Answers  

How do I partition a table in sql?

0 Answers  

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

Can a commit statement be executed as part of a trigger?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories