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 / sandip kumar chaturvedi

index is a data structure that improve the operation on
table.there are two types of index.
1) ordered index.
2) hashed index.
up to 249 clustered indexes per table.

Is This Answer Correct ?    20 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are local and global variables and their differences? : Sql dba

1069


What is sql prepared statement?

976


how to dump a table to a file with 'mysqldump'? : Sql dba

1035


What is a left inner join?

1011


What is update query?

973


Define a temp table?

1016


How do you respond to dementia behavior?

964


What are the subsets of sql?

1127


How many triggers can be applied on a table?

930


What are sql functions? Describe in brief different types of sql functions?

1100


Explain the difference in execution of triggers and stored procedures?

1018


What is sql and its types?

1175


How do you update f as m and m as f from the below table testtable?

1849


How delete all data from all tables in sql?

944


What are the types of optimization?

950