Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38446 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / venkat reddy.ravu
**clustured index unique for a table,that reorders the data
which is physically stored in a table.Leaf node ie end
point of the clustured index contains the data pages.
**non clustured indexes logical order doesent meets the
physical order of the data in disk.leaf nodes of non
clustured indexes not contains data pages,instead contains
index rows.we can create 249 non clustured indexes on a
table.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What are the general features of sql server management studio? : sql server management studio
what are database files and filegroups? : Sql server database administration
Explain the usage of floor function in sql server.
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Are semicolons required at the end of sql statements in sql server 2005?
What are sub reports and how to create them?
If no size is defined while creating the database, what size will the database have?
What are the source of constraints?
How is sql used in sql server?
What are commonly used mssql functions in php?
How to create new tables with "select ... Into" statements in ms sql server?
What methods do you follow to protect from sql injection attack?
How to concatenate two strings in SQL Server.
Why are sql functions used?
What is normalization and its types?
