Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes? When do you need to create Indexes?
- 4 Answers
- 8000 Views
- CarrizalSoft Technologies, HP, I also Faced
- E-Mail Answers
Answer Posted / murtaza
INDEXES:
1.indexes are used for performance as well as query
optimization issues in database.
2.indexes are by default created when u create an primary or
unique index on a particular column in a table.
3.In sql server there are 2 types of indexes
1.clustered index
2.non clustered index
4.By default non clustered index are created in sql server 2005.
WHEN TO CREATE INDEXES:
1.indexes should be created on the tables which will be used
frequently.
2.it should be created on d tables which has large amount of
data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are commonly used mssql functions in php?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What are cascading parameters in ssrs reports?
what is a correlated sub-query? : Sql server database administration
What are the purposes of floor and sign functions?
What are the methods used to protect against sql injection attack?
Can a table have 2 primary keys?
What are “lost updates”?
What do you mean by normalisation?
What are the advantages of sql azure?
Write SQL queries on Self Join and Inner Join.
Explain different types of self contained sub query?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to get the definition of a view out of the sql server?
What programming language would you use to create embedded functions in ssrs?
