Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is an index and types of indexes. How many number of
indexes can be used per table ?

Question Posted / rm thirunavukkarasu

Answer Posted / rm thirunavukkarasu

Index is used to Retrive the Information in efficient
manner. And query processor perform reliably.

There are 3 types of Index namely
*Cluster based Index
*Non Cluster based Index
*Noncomposite Index
*Compositive Index
*Unique Index

For more info adt sql plz visit www.thiruna.blog.com

Is This Answer Correct ?    8 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is postgresql a server?

736

Is json a nosql?

723

how can you create an empty table from an existing table? : Sql dba

858

Is primary key is clustered index?

724

How do I sort a table in sql?

765




What is the starting oracle error number? What is meant by forward declaration in functions?

738

What does cursor do in sql?

712

what are the disadvantages of mysql? : Sql dba

761

Which tcp/ip port does sql server run?

715

how to shut down the server with 'mysqladmin'? : Sql dba

734

What is the source code of a program?

707

What is a null value?

845

What is difference between hql and sql?

701

What is right join in sql?

744

Can delete statement be rollbacked?

729