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...

How do you know which index a table is using?

Answer Posted / chandra rekha

sp_helpindex command gives the information of the indexes
on the table

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete database objects with "drop" statements in ms sql server?

1067


Can you tell me some of the common replication dmv's and their use? : sql server replication

902


Explain what is row_number function?

1004


What is a join in sql?

1069


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

988


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

966


Explain system functions or built-in functions? What are different types of system functions?

955


What are the pre-defined functions in the sql server?

1081


What is buffer cash in sql server?

1138


Is it possible to replicate data from sql server to oracle? : sql server replication

1070


What number aggregate functions are accessible there in sql?

1046


Distinguish between commit and rollback?

940


What is fill factor and pad index?

996


 Explain what is sql override for a source taLle in a mapping?

988


How to convert a unicode strings to non-unicode strings?

1078