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?
Answer Posted / 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 View All Answers
Is like operator in sql case sensitive?
How does one load ebcdic data? : aql loader
Why should I use postgresql?
What is the purpose of cursors in pl/sql?
What are the types of operators available in sql?
Does a user_objects view have an entry for a trigger?
What is sql mysql pl sql oracle?
What does count (*) mean in sql?
What is trigger in sql? Explain
What is varchar data type in sql?
Can you call pl/sql package functions from within a fast formula?
How many types of normalization are there?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is dynamic sql in pl sql?
what is bdb (berkeleydb)? : Sql dba