Interested to Buy Any Domain ? << Click Here >> for more details...
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 sql server means?
What is PROJECTION Operation?
Explain powershell included in sql server 2008?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
List some advantages and disadvantages of stored procedure?
Define constraints and give an example of their use?
What are the properties of the relational tables?
What is the difference between for auto and for nested?
What are clustered and non-clustered index?
How many non clustered indexes there can be on table ?
How to deploy the Report?
Explain unique key in sql server?
What is explicit mode in sql server?
Explain “not null constraint” in sql server?
What is table constraint?
