Answer Posted / c.jagadish
In sqlserver we have two types of indexes (1) Clustered (2)
non clustered indexes.
Indexes may be simple index or composite index.
Index formed based on single column values is called simple
index
index formed based on multiple column values is called
composite index.
Default index is NON CLUSTERED INDEX
When a table contains a primary key column then sqlserver
automatically creates a unique clustered index.
Unique--- automatically creates a non clustered index
so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT
NULL.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the types of dml?
Why it is recommended to avoid referencing a floating point column in the where clause?
How do I create a stored procedure in sql server?
What are xml indexes?
What is the difference between row_number and dense_rank?
How do I get to sql server configuration manager?
What is clustered index
How to create a simple stored procedure in ms sql server?
What is difference between group by and having?
Can you type more than one query in the query editor screen at the same time?
Explain full-text query in sql server?
Can you explain full-text query in sql server?
How to search for a string in all stored procedure in sql server?
what's the information that can be stored inside a bit column? : Sql server database administration
What are the components of sql server service broker?
