Interested to Buy Any Domain ? << Click Here >> for more details...
When do u use clustered index and non-clustered index?
- 3 Answers
- 8969 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
How many levels of sp nesting are possible?
Mention the differences between local and global temporary tables.
Can we do dml on views?
What is tablesample?
Define left outer join in sql server joins?
How many database files are there in sql server 2000?what are they?
How to set database to be single_user in ms sql server?
What language is sql server written in?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
how to control the amount of free space in your index pages? : Sql server database administration
Explain different types of collation sensitivity?
What is nonclustered index on computed columns?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Define a cross join?
can you instantiate a com object by using t-sql? : Sql server database administration
