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 do I create a partition table in sql server?

0 Answers  

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

What are the five major components of a dbms?

0 Answers  

How many types of Cursor in SQL SERVER?

1 Answers  

Explain what are magic tables in sql server?

0 Answers  




I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

What is blocking and how would you troubleshoot it?

2 Answers  

Explain what is cte (common table expression)?

0 Answers  

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

Define indexes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories