Order of Index, how it works?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Essa - 29 Mar 2005 16:03 GMT

Hi All;

I have a table and it has one primary key i.e. BID , one Foriegn Key LOCID
and one EntryDate column which has datetime datatype. It has so many other
columns. We do most of the searches on LocID and EntryDate. This table
contains data in millions. We already have index on LocID and now we are
thinkning to create index on EntryDate.

My question is that:

1- How would it work in terms of Order , first it will order all the data
with LocID and then EntryDate ?

2- How does the Order of Creating Index affect the results?

3- How would it help us in searching data if we create Index on EntryDate?

I am new in Index Topic.

Thanks.

Signature

Essa, M. Mughal
Software Developer
Canada

Reply to this Message

Adam Machanic - 29 Mar 2005 17:13 GMT

Asked and answered on the SQLJunkies forums (
http://www.sqljunkies.com/forums ) -- please do not multipost, especially in
totally different places! (and especially, especially not two places I
frequent)

Signature

Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--

> Hi All;
>
[quoted text clipped - 16 lines]
>
> Thanks.

Reply to this Message

stooky - 16 Apr 2005 02:54 GMT

Asking someone to NOT post on multiple websites is absolutely ridiculous. If
your regular movie store doesn't have the movie you want, do you just go home
or try the store across the street?

Multi-posting on the same site in different categories is a no no, but
across sites, well....that just makes sense.

stooky.

> Asked and answered on the SQLJunkies forums (
> http://www.sqljunkies.com/forums ) -- please do not multipost, especially in
[quoted text clipped - 21 lines]
> >
> > Thanks.

Reply to this Message

Adam Machanic - 16 Apr 2005 14:17 GMT

> Asking someone to NOT post on multiple websites is absolutely ridiculous. If
> your regular movie store doesn't have the movie you want, do you just go home
> or try the store across the street?
>
> Multi-posting on the same site in different categories is a no no, but
> across sites, well....that just makes sense.

It only makes sense if the question went unanswered for a good amount of
time. In this case, the same question was posted within a few minutes, to
two forums that I happen to visit frequently. I had already answered the
question on SqlJunkies -- why should someone in this newsgroup have to waste
their time answering it again?

Signature

Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--

Reply to this Message