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
How to define and use table alias names in ms sql server?
What is ms sql server index?
What is the server name in sql server?
What is the difference between commit and rollback?
How to override dml statements with triggers?
What do you understand by mirroring?
What is in place upgrade in sql server?
what are database files and filegroups? : Sql server database administration
What is the federation in sql azure?
What are the recovery models for a database?
What is the full form of ddl?
What is page-level compression?
What is the difference between row_number and dense_rank?
How to find out the list schema name and table name for the database?
What are views in ms sql server?