can we create index on index?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / g.rajesh

7 Answers
15807 Views
iFlex, Symphony, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can we create index on index?..

Answer / divya

Is This Answer Correct ?

5 Yes

1 No

can we create index on index?..

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

can we create index on index?..

Answer / akhilesh c

no , you can create Index on index

Is This Answer Correct ?

1 Yes

1 No

can we create index on index?..

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

can we create index on index?..

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

can we create index on index?..

Answer / junhua

seems IOT can do this

Is This Answer Correct ?

1 Yes

5 No

can we create index on index?..

Answer / saroj

yes

Is This Answer Correct ?

4 Yes

9 No

Post New Answer