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 inner outer left and right joins in sql?
Can we connect to postgresql using sql developer?
How to get second highest salary from a table
explain the options of myisamchk to improve the performance of a table. : Sql dba
Explain the difference in execution of triggers and stored procedures?
What can sql server reporting services do?
What is rownum and rowid?
How did you export data from database to excel file.
What is Temp Table and type of temp table?
When can we use the where clause and the having clause?
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On
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)