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

Cite the differences between execution of triggers and stored procedures?

1075


What is cte sql?

985


What is db journal file?

1055


What is the difference between syntax error and runtime error?

1137


What is the best partition size for windows 10?

999


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2491


What is the difference between cross join and natural join?

1014


How do you write a subquery?

1023


What is update query?

973


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1434


What is record type in pl sql?

984


Explain the savepoint statement.

1090


define join and explain different type of joins? : Sql dba

948


Enlist the data types that can be used in pl/sql?

1062


What steps server process has to take to execute an update statement?

973