Answer Posted / dharmendra k dixit
INDEX are physical address of data, its is same just we
Have indexes in our Book..through this we can make our
search much faster.
in Idle way always try to make Indexes on that Column which
have Integer Value(i.e. Not on text type).
There are two types of Indexes in SQL SEREVR
1. Clusterd Index.(Create automatically if there is a
Primary key on Table)
2. Non Clusterd Index.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain the rules for designing files and file groups in sql server?
How do I find the size of a sql server database?
How to convert a numeric expression from one data type to another?
What is the purpose of the model database?
when you create a database how is it stored? : Sql server database administration
What is the significance of master, tempdb and model databases?
How to download and install sql server 2005 books online?
What are the authentication modes in sql server? How can it be changed?
What is a join in sql?
What is the Main Difference between ACCESS and SQL SERVER?
What is a trigger and types of a trigger?
What are the new features of sql server 2008 r2 reporting service?
What is the difference in accessing db between sql server vs sql azure?
How to Insert multiple rows with a single insert statement?