Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38202 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / s.purushothaman
The difference between a clustered index and a non-clustered index is that when you use a clustered index, the section of the table that comprises the index has its data pages linked differently from those data pages comprising a non-clustered index.
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How important do you consider cursors or while loops for a transactional database?
What is log in sql server?
What are the 10 characteristics of data quality?
Can we add an identity column to decimal datatype?
How to add additional conditions in SQL?
How to get the definition of a stored procedure back?
How to create hyperlink from returned sql query ?
What is a virtual table in sql?
What types of Joins are possible with Sql Server?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is “asynchronous” communication in sql server service broker?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
Differentiate between a local and a global temporary table?
