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 is package in pl sql with an examples?

1035


Is id a reserved word in sql?

1145


What are all the different types of indexes?

1147


What is structural independence and why is it important?

1031


what is meant by urlencode and urldocode? : Sql dba

1174


who introduced sql?

1018


What does an inner join do?

1179


What is t sql used for?

1012


What is minus?

988


What is the difference between function, procedure and package in pl/sql?

1259


How many types of sql are there?

986


What is the location of pre_defined_functions.

1166


How do I tune a sql query?

974


Define a temp table?

1016


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1034