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 / swapna vamsi

Indexs are used for the faster retrivel of data.

two types of indexes
Cluster index,unclustered index
we can have one cluster index and uotp 249 cluster indexes
for a table

Is This Answer Correct ?    63 Yes 38 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which tcp/ip port does sql server run?

1014


What is basic structure of pl sql?

1074


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2172


What is an invalid partition table?

1027


What packages are available to pl/sql developers?

1064


How many types of cursors are available in pl/sql?

1111


Differentiate between pl/sql and sql?

1154


What are the different operators available in sql?

1004


What does pl sql developer do?

935


Can we use joins in subquery?

1166


What is dynamic sql in pl sql?

1038


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

1860


What is loop in pl sql?

1040


Can you join views in sql?

960