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 loop in sql?

0 Answers  

Is sql port 1433 encrypted?

0 Answers  

What are the indexing methods?

0 Answers  

Can we join more than 2 tables in sql?

0 Answers  

What are the two parts of design view?

0 Answers  

What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

How do I send sql query results to excel?

0 Answers  

What is the difference between local variables and global variables?

0 Answers  

What is CYCLE/NO CYCLE in a Sequence?

2 Answers  

what is sql profiler

2 Answers   Fidelity,

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

Which command is used to delete a trigger?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories