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 advantages of normalization?
What are the new features in Oracle 10g. Compared to Oracle 9i?
How can a pl sql block be executed?
what is top in tsql? : Transact sql
in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
Does inner join remove duplicates?
Is sql a backend language?
what is a stored procedure? : Sql dba
declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?
Difference between aggregate function and analytical function?
Can we insert data into materialized view?
What is a database event trigger?
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)