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 does the on delete cascade option do?
What is a unique index?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are the advantages of using third-party tools?
What methods do you follow to protect from sql injection attack?
How we create SQL Server 2005 Reporting Services ? Give me Sample
How to insert multiple rows with a subquery?
What is the difference between getdate and sysdatetime?
Will the writetext statement activate a trigger?
Explain how you can deploy an SSRS report?
what is sql server? : Sql server database administration
What is the main difference between ‘between’ and ‘in’ condition operators?
Does the order of columns in update statements matter?
Can we use where clause with group by?
Explain error and transaction handling in sql server?
