can we create index on index?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are stored procedures used for?

537


What is asqueryable?

533


What is record data type?

518


What do you mean by stored procedures? How do we use it?

525


What is constant in pl sql?

519






what are the types of join and explain each? : Sql dba

532


Explain about various levels of constraint.

525


What is foreign key and example?

517


is it possible to pass an object or table to a procedure as an argument?

574


What does subquery mean in sql?

542


What is multiple partition?

539


Which is faster subquery or join?

661


Why do we use set serveroutput on?

518


What is the difference among union, minus and intersect?

546


How do I count rows in sql query?

491