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 / 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 |
Can we create view in stored procedure?
What are data types in pl sql?
What is a call statement? Explain with an example.
How do I audit the sql sent to the server?
When is the explicit cursor used ?
How to fetch records from a partitioned table?
how can i read files from a pl/sq l program
What is not equal in sql?
what are tables and fields? : Sql dba
What is the primary use of normalization?
What is cold data?
declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?