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 |
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
How to make a copy values from one column to another in sql?
Define union, minus, union all, intersect ?
How to Execute a Package in PL/SQL.?
What is primary and foreign key?
How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?
What is sql in oracle?
What is integrity constraints?
In packages the source code is compiled into p code ? how do we describe the p code
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
where are cookies actually stored on the hard disk? : Sql dba
What is meant by truncate in sql?