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

Why union all is faster than union?

0 Answers  

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

What are subquery and its properties?

0 Answers  

How secure is sql server database?

0 Answers  

What command must you use to include the not null constraint after a table has already been created?

0 Answers  

How do you test your database? : sql server database administration

0 Answers  

What are the differences between char and nchar in ms sql server?

0 Answers  

What are user defined functions in ms sql server?

0 Answers  

Can an entity have two primary keys?

0 Answers  

What is sql view?

0 Answers  

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories