Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54928 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / durgaprasad
no its not possible to place clustered index on non key
column once the table contains any one key column, bcoz key
column itself contains one clustered index based on that
data sorted in ascending order.if u place one more
clustered index how it is possible to arrange the data in
soreted order.
| Is This Answer Correct ? | 15 Yes | 29 No |
Post New Answer View All Answers
How many types of schemas are there?
What is the difference between createstatement and preparedstatement?
What is a full text index?
A trigger can reference objects outside the current database? State true or false.
Explain what is lock escalation and what is its purpose?
What is a subquery in a select query statement in ms sql server?
What command is used to delete a table from the database in the sql server and how?
Describe how to use the linked server?
Write a query to find 5th highest amount paid from the customer table.
in the physical file layout, where should the transaction log be stored in relation to the data file?
What are the approximate numeric data types?
How can you append an identity column to a temporary table?
How efficient you are in oracle and SQL server?
Mention the command used to rename the database.
What are the steps to insert a table?
