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 is a domain constraint give an example?

0 Answers  

What is row_number () and partition by in sql server?

0 Answers  

What are the different authentication modes in sql server?

0 Answers  

How to remove duplicate rows from table except one?

0 Answers  

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

What is postgresql server?

0 Answers  

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

How to Update from select query in sql server?

0 Answers  

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

How to create an inline table-valued function?

0 Answers  

can you any body tell me the difference between candidate key and primary key

4 Answers  

For more SQL Server Interview Questions Click Here
Categories