Interested to Buy Any Domain ? << Click Here >> for more details...
can we create index on index?
- 7 Answers
- 15780 Views
- iFlex, Symphony, I also Faced
- E-Mail Answers
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 |
Do stored procedures prevent sql injection?
Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
how would you get the current date in mysql? : Sql dba
What is cte sql?
Which command is used to call a stored procedure?
Can you alter start with clause?
List and explain the different types of join clauses supported in ansi-standard sql?
Does pl/sql support create command?
What is full join in sql?
How do you write an inner join query?
How to display the current date in sql?
function can return multiple value?how give give sample coding
2 Answers 3i Infotech, CTS, Excelity Global, UHG,
-
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)
