Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do you know which index a table is using?

Question Posted / guest

Answers were Sorted based on User's Feedback



How do you know which index a table is using?..

Answer / hari

sp_helpindex tabelname

Is This Answer Correct ?    14 Yes 1 No

How do you know which index a table is using?..

Answer / chandra rekha

sp_helpindex command gives the information of the indexes
on the table

Is This Answer Correct ?    10 Yes 1 No

How do you know which index a table is using?..

Answer / visala

sp_help <tablename>
sp_helpindex <tablename>

Is This Answer Correct ?    9 Yes 2 No

How do you know which index a table is using?..

Answer / vimal

dbcc traceon 302

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL Server Interview Questions

what is difference between having and where clause ?

3 Answers  

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

What is the query and subquery?

0 Answers  

Describe in brief system database.

0 Answers  

What are entities and relationships?

0 Answers  




How to list all user defined functions in the current database?

0 Answers  

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

What is Replication?

0 Answers  

What is the default fill factor value?

0 Answers  

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

What is SubQuery in SQL Server 2008

0 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories