There is a table, In one column it has implemented a index, but the index is d

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

1 Answers
6618 Views
Cognizant, I also Faced
E-Mail Answers

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 to get the third quarter of employee details from emp?

2 Answers CompuTech,

What is normalization and types of normalization?

22 Answers Etisbew, F-TEC, Microsoft, TechProcess,

How to call shell script from pl sql procedure?

0 Answers

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers

What is not null in sql?

0 Answers

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers JPMorgan Chase,

what is the use of HASH, LIST partitions?

1 Answers ITC Infotech,

What are keys in sql?

0 Answers

what is 'mysqlimport'? : Sql dba

0 Answers

What is rule base and cost base optimizer?

2 Answers Thermotech,

how are mysql timestamps seen to a user? : Sql dba

0 Answers

How is data stored on a disk?

0 Answers

For more SQL PLSQL Interview Questions Click Here