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 requirements for sql server 2016?

0 Answers  

What is nolock?

0 Answers  

What are the various editions of sql server 2017 that are available in the market?

0 Answers  

what is meant by deafult in sql server?

2 Answers  

What are translations and its use? : sql server analysis services, ssas

0 Answers  

What are filegroups in sql server?

0 Answers  

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

What is an execution plan? When would you use it?

0 Answers  

How do you delete duplicate records in sql server?

0 Answers  

What is INTVAL( )and where we use Plz any body help me

1 Answers  

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

How to rename an existing column with sql server management studio?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories