Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 55373 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / surya prakash
Finally, i want to conclude by saying.
1. We can create Clustered Index on Non-Primary Key Columns
and this table should not contain any other column with
Primary Key.
2. It is recommended that we create Clustered Indexing on
Primary Key Columns
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
How retrieve field names from the table in SQL through JAVA code?
Define left outer join in sql server joins?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What is difference between order by and group by?
Can two tables share the same primary key?
what are the new features in SSRS?
How to defragment indexes with alter index ... Reorganize?
Why do we need different type of parameter?
Why do we partition data?
Can you please differentiate between a primary key and a unique key?
How do I find the transaction log size in sql server?
How to return the top 5 rows from a select query in ms sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What are the different type of replication in sql server?
