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 |
How do we use distinct statement? What is its use?
What is the difference between left join and right join?
Is natural join same as inner join?
What are keys in sql?
How to run pl/sql statements in sql*plus?
What is triggering circuit?
How do you determine the current isolation level? : Transact sql
How many functions are there in sql?
Is oracle sql free?
what is data integrity
How can i insert data inro a table with 3 columns using FORALL?
List and explain the different types of join clauses supported in ansi-standard sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)