Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes? When do you need to create Indexes?
- 4 Answers
- 8186 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
Explain aggregate functions?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is sql or structured query language?
What are the benefits of normalization?
What is always encrypted?
What are different types of database indexes?
How to create an index on a view?
What is table constraint?
What do you understand by sql server agent?
What is forward - only cursors / read only cursor?
Explain cross join or cartesian product in sql?
What are the 3 types of schema?
List out the difference between union and union all in sql server?
what is a traditional network library for sql servers? : Sql server database administration
