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

What does desc stand for?

1122


How do I write a sql query in pgadmin 4?

1046


what is self join and what is the requirement of self join? : Sql dba

1191


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1072


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1042


How to revise and re-run the last sql command?

1218


What is the difference between cross join and natural join?

1066


State some properties of relational databases?

1115


What is asqueryable?

1035


What is the use of desc in sql?

1022


Does sql view stored data?

1003


What company owns postgresql?

1089


What are different functions in sql?

998


Why are indexes and views important to an organization?

998


what is a trigger in mysql? Define different types of trigger. : Sql dba

1117