When do u use clustered index and non-clustered index?
- 3 Answers
- 8232 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pradeep
To increase the performance of database we can use clustered Index .It will be in sorted order and it is in the form of B tree structure and it won't accept nulls.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain the stored procedure?
What are sub reports and how to create them?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
How would you go about developing a ssrs report?
What do you need to connect php to sql server?
Explain linked server in sql?
What do you do in data exploration
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
When is the use of update_statistics command?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How can you hide the sql server instances?
What do you understand by a stored procedure?
Do you know what is a trace frag? Where do we use it?
Does an index slow down updates on indexed columns?
What are the general features of sql server management studio? : sql server management studio
