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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / vinod

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / laxman

we need to use indexed column in where clause

Is This Answer Correct ?    1 Yes 0 No

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

Answer / nixo

In the case search is the query. How would you search in
the database? I think you will use sql query.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are the advantages of policy management?

0 Answers  

What do you understand by a stored procedure?

0 Answers  

How to concatenate two binary strings together?

0 Answers  

When we should use and scope of @@identity?

0 Answers  

How to add additional conditions in SQL?

0 Answers   Amdocs,

What is an example of a primary key?

0 Answers  

What is optimistic concurrency?

0 Answers  

What are logical database components? : SQL Server Architecture

0 Answers  

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

can you any body tell me which service pack is installed in the sql server?

3 Answers  

How to provide login information for a new odbc dsn?

0 Answers  

How to generate create function script on an existing function?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories