Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes? When do you need to create Indexes?
- 4 Answers
- 8214 Views
- CarrizalSoft Technologies, HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to use user defined functions in expressions?
How the authentication mode can be changed?
How to list all objects in a given schema?
What is the use of sign function?
Explain what is scheduled job and how to create it?
How does Report Builder support Analysis Services cubes?
How do I install only the client tools of sql server 2000?
Explain the microsoft sql server delete command?
Explain indexes disadvantages?
What are the types of sql server?
What is difference between oltp and olap?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is clustered vs nonclustered index?
What is sub query and its properties?
How to create stored procedures with parameters in ms sql server?
