can we create index on index?
Answers were Sorted based on User's Feedback
Answer / ankush
An index creates an entry for each value that appears in
the indexed columns.
Then why it is necessary to create an index on the same
index.
as An index is a performance-tuning method of allowing
faster retrieval of records.
NO we can't create index on index.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ramaraju
No, once we will try to create index on index we will get this error
ERROR at line 1:
ORA-01408: such column list already indexed
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / s.syam sundar
hi saroj,
please let me know that how can we create a index on index
usege of this kind of indexs
how it will work
thankks
syam sundar
Is This Answer Correct ? | 2 Yes | 3 No |
Explain the difference in execution of triggers and stored procedures?
How many unique keys can a table have?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Explain the working of primary key?
What is sqlite format?
How do we use distinct statement? What is its use?
Why is normalization important?
i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w
4 Answers Scope International,
How we can update the view?
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
what is a database lock ? : Sql dba
What type of database is sql?