Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 55370 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / leelavinoth
I have created CLUSTERED on NON-PRIMARY Attribute because i
want my table has to be ordered in NON-PRIMARY column.
Because, most on my search and filtering will be on this
NON-PRIMARY column.
Is there any harm in this! Please recommend
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
can a table be moved to different filegroup? : Sql server administration
How can you start sql server in different modes?
what is an index? : Sql server database administration
Comment,Datatypes are unlimited
What is the purpose of linked server configuration in sql server?
Explain how many normalization forms?
What are page splits?
How to bind a view to the schema of the underlying tables?
How to verify the port number of the sql server?
How to retrieve error messages using odbc_errormsg()?
Do you know the policy based administration feature of sql server 2008?
What is the difference between the 2 operating modes of database mirroring?
do you know how to configure db2 side of the application? : Sql server database administration
Can group functions be mixed with non-group selection fields in ms sql server?
What are the two authentication modes in sql server?
