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 are Dynamic SQL statements?

9 Answers  

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

What is the difference between a database and a relational database?

0 Answers  

What is query syntax?

0 Answers  

Where do we use pl sql?

0 Answers  

What is online transaction processing (oltp)?

0 Answers  

What is primary and foreign key?

0 Answers  

How to use sql*plus built-in timers?

0 Answers  

Where the sql database files are stored?

0 Answers  

What is the difference between local variables and global variables?

0 Answers  

What is attribute indicator in pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories