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

Is mysql better than sql server?

1059


What are the advantages of user defined function?

980


What is collation sensitivity?

1054


What are different replication agents and what's their purpose? : sql server replication

1006


What command would you use to add a column to a table in sql server?

1304


Name few endpoints exposed by ssrs 2012?

355


Is oracle faster than sql server?

947


What are the properties of sub-query?

1066


Can you insert NULL in unique column?

1152


what stored procedure would you use to view lock information? : Sql server administration

967


What are points to remember while using the fillfactor argument?

963


What are subquery and its properties?

1041


What is coalesce in sql server?

1048


Explain the creation and execution of a user-defined function in the sql server?

1045


What does it mean to invest in the index?

958