Is it good to add a NonClustered index without Clustered Index

Question

0.00/5 (No votes)

See more:

Hi,

There is a table Consumer with fields
ImportDate DateTime
AccountNo Varchar(40)
AccountType Int
Name Varchar(40)
IDType Int
Country Int

There is no Primary Key in this table, and is it good for adding a NonClustered index on the ImportDate.

Posted 2-Jun-14 22:19pm

clintoaug

Updated 2-Jun-14 22:41pm

v4

Add a Solution

Comments

Jörgen Andersson 3-Jun-14 10:02am

Yes it's fine, but do add a primary key in any case.

Richard Deeming 3-Jun-14 11:54am

NB: A primary key is not the same thing as a clustered index. It's quite possible to use a non-clustered index to support a primary key, and it's also possible to create a clustered index on a table without a primary key.

If what you've posted is the entire table definition, and records are always added with a newer ImportDate, I'd look at adding a clustered index to the ImportDate column, possibly adding secondary columns as required by your data. You'll still be able to have duplicate values in the fields; it just means the records will be physically stored in a logical order.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Answer 1 · 2014-06-03T19:33:00

Solution 1

hi clintoug,

Is not a question of yes/no, This is some thing you have to learn about these two type of indexes fist

so here is one good discussion over these indexes

http://stackoverflow.com/questions/4034076/reasons-not-to-have-a-clustered-index-in-sql-server-2005[^]

Posted 3-Jun-14 19:33pm

RDBurmon