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 is using in sql?

789


What is sql dialect?

738


Is primary key clustered or nonclustered?

739


Is ms sql is free?

710


What is error ora-01000: maximum open cursors exceeded

783






What is cost in sql execution plan?

680


Is natural join and inner join same?

651


What is difference between stored procedures and application procedures?

761


Can we join two tables without common column?

695


What is a sql instance vs database?

763


What happens when a trigger is associated to a view?

673


What jobs use sql?

719


Write a query to display the current date in sql?

737


Why should I use postgresql?

755


What is the difference between database trigger and stored procedure?

738