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...

We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?

Answer Posted / ish

It is depend on which type of indexing u r using .
clustered or non clustered.

if u r searching one record then used nonclustered indexing.
if u r searching bulk of record then used clustered indexing

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain nested join?

1030


Data table as parameter in sql server?

1102


User wants only to display only pdf as export option in report manager. How to achieve this?

269


Is it safe to delete log files?

970


What is service broker?

1060


Explain the benefits of user-defined functions?

1120


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

1007


What is the difference between local and global temporary tables?

1193


What is statement level trigger?

1045


How to attach adventureworkslt physical files to the server?

1160


What is trigger in salesforce?

1051


What are the requirements to use odbc connections in php scripts?

1156


What is the difference between the 2 operating modes of database mirroring?

1160


How many full-text indexes can a table have?

1022


What is BCNF? How is it better than 2NF & 3NF?

1065