Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 7445 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
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?
What are basics of policy management?
What is the difference between functions and scalar functions?
Explain indexing and what are the advantages of it?
What is schemabinding a view?
What happens if date-only values are provided as date and time literals?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is extended stored procedures?
What is sql server profiler trace data file?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How to create prepared statements using odbc_prepare()?
What are the advantages of partitioning?
What are points to remember while using the fillfactor argument?
Why use view instead of a table?
What are cursors in ms sql server?
