Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / diptabhaskar ray

the ordering of a table in a database is called index.it
helps in fast access to the specific information.the column
suitable for index should be a primary key or a foreign
key,should be sorted,joins should be allowed and users will
search for data.clustered index and non clustered index.

Is This Answer Correct ?    20 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the built in functions of sql?

1030


What is difference between stored procedure and trigger?

1171


What is a table?

1021


What does select top 1 do in sql?

1102


What is the unique index?

1054


What is trigger types of trigger?

1073


What is sql partition function?

1215


What are the two characteristics of a primary key?

983


What are the types of queries in sql?

1086


what are the differences between char and nchar? : Sql dba

1115


what are tables and fields? : Sql dba

1059


How do I restart sql?

979


Is pl sql different from sql?

1001


What is informix sql?

983


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

994