Can we create clustered index on non primary key column
- 20 Answers
- 51795 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
YES, We can create a clustered index on a non-primary
column. Check the folowing queries...
CREATE TABLE EMPLOYEES
(
empid int NOT NULL CONSTRAINT ix_pkEMPLOYEES PRIMARY KEY
NONCLUSTERED
, name varchar(25) NOT NULL
, age tinyint NOT NULL
)
CREATE CLUSTERED INDEX ixcEMPLOYEES ON EMPLOYEES (name)
| Is This Answer Correct ? | 57 Yes | 6 No |
Post New Answer View All Answers
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is the use of RDBMS?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Can I save my report as html, excel or word? : sql server management studio
What is co-related sub query?
How many databases can we create in a single server?
Do you know what is user defined datatypes and when you should go for them?
What is failover clustering overview?
What is the difference between upgrade and migration in sql server?
What are logical database components? : SQL Server Architecture
How to provide login information for a new odbc dsn?
What happens if null values are involved in arithmetic operations?
What is the difference between inner join and equi join?
Explain the disadvantages of cursors?
What is microsoft sql server?
