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

Tell me what is log shipping?

0 Answers  

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

Describe triggers features and limitations?

0 Answers  

What is temporal data type?

0 Answers  

How many database files are there in sql server 2000?what are they?

0 Answers  




What are the recovery models for a database?

0 Answers  

can you any body tell me the how to decrease the logfile

4 Answers  

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

How to create new table with "create table" statements?

0 Answers  

Explain what is meant by replication of database?

0 Answers   Cap Gemini,

Can we use where clause in union?

0 Answers  

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories