What are indexes? When do you need to create Indexes?
Answers were Sorted based on User's Feedback
Answer / bhagwat sharma
When data volumes increase, organizations are faced with
problems relating to data retrieval and posting. They feel
the need for a mechanism that will increase the speed of
data access. An index, like the index of a book, enables the
database retrieve and present data to the end user with
ease. An index can be defined as a mechanism for providing
fast access to table rows and for enforcing constraints.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rajeev
Index is used for fast searching and batter performance.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Answer / radhakrishnan
index : increase the performance of sql statement.
When we create :
1) large number of data in table
2) most of null value in specific column
3) multiple join in sql statement
4) less than 2% of data retrive from table
when we not create :
1) frequently update the table
2) less number of data
Type of Index :
1) clustered index
- primary & unique constaint cretae autoatically for this
index
- only one clustered index per table.
- data sorted physical order
- Eg : book front index
2) non clustered index
- create multiple index per table.
- Eg : book back index
Syntax :
Create index index_name on tablename (column name)
Is This Answer Correct ? | 1 Yes | 0 No |
What is checkpoint in sql server?
What are the operating modes in which database mirroring runs?
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
What is default constraint?
What is the command dbcc checkdb used for?
Write the syntax for stuff function in an sql server?
how many type of subquery?
What should be the fill factor for indexes created on tables? : sql server database administration
How do I find the sql server database version?
How to get last system shutdown time in Sql server when restarted system?
What is the difference between Normalization and De-normalization?
What is the difference between clustered and non-clustered indexes in ms sql server?