Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 7469 Views
- Progressive, I also Faced
- E-Mail Answers
Answer Posted / anjan ghosh
when we create index then we assign a primary or unique
field , after insert of records , the results is
clustered--(field) order by
nonclustered--no order(logical order)
create table nonclusterindex(Emid int,data varchar(800))
create table clusterindex(Emid int,data varchar(800))
create unique nonclustered index nonclusterindex_emid on
nonclusterindex (Emid)
create unique clustered index clusterindex_emid on
clusterindex (Emid)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Distinguish between nested subquery and correlated subquery?
How to download microsoft sql server 2005 express edition?
What are the properties and different types of sub-queries?
what is the difference between Delete and Truncate command in SQL
What are horizontal and vertical scaling?
Can sql servers link to other servers like oracle?
Write the syntax for stuff function in an sql server?
What command would you use to add a column to a table in sql server?
Can we perform backup restore operation on tempdb?
How to backup SQL Server Reporting Services ?
How do you check sql server is up and running?
What are views in ms sql server?
How do I clean up sql server transaction log?
can an automatic recovery be initiated by a user? : Sql server administration
What are sql azure firewall rules?
