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 |
What are the sql aggregate functions?
Why do we use joins?
How many postgresql users are there, worldwide?
Can we insert data in view?
What is before trigger?
What are the basic sql commands?
Define implicit and explicit cursors.
What is left inner join in sql?
how to see the create table statement of an existing table? : Sql dba
Can we use ddl statements in stored procedure?
What are nested triggers ?
6 Answers Amazon, Appeal Soft, IBM, Infosys, TCS,
What is use of trigger?