Interested to Buy Any Domain ? << Click Here >> for more details...
When do u use clustered index and non-clustered index?
- 3 Answers
- 8842 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
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is advantage data architect?
Explain features and concepts of analysis services?
What is cursors?
Write a program using SQL queries to find a unique entry in a table.
How does a profiler work?
Explain forward - only cursors?
What are examples of triggers?
What is page in sql server?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What are system databases in ms sql server?
How to connect of datebase with sql express.?
Can group by and orderby be used together?
What is clustered primary key?
What is simple indexing method?
