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

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

What is the purpose of a table?

0 Answers  

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

What are window functions in sql server?

0 Answers  

What is normalization in Database ?

4 Answers  

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

What is repeatable read?

0 Answers  

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

Can we hide the definition of a stored procedure from a use?

0 Answers  

What is the sql profiler?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories