Re: DATE-column part of index ?

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/05/27
Message-ID: <338af053.30030496@www.sigov.si>#1/1

On 27 May 97 14:34:58 +0100, vermaat_at_gemini.tfdl.agro.nl wrote:

>I was asked by a collegue if it is OK to include a DATE-column is an index.
>Ik remember vaguely that someone told me years ago not to do that, but I am
>not sure and I do not remeber the reason for not including such a column.
>Anyone who has an opinion on this matter ?
>********************************************************************************
>| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |

---

>| p.j.r.vermaat@fd.agro.nl | http://www.agro.nl/~vermaat/ |

---

>| Yes yes, but this is all extremely vexing ! I'm quite put out ! |
>********************************************************************************

There is absolutely no reason at all not to include date column in an index!

Regards,

Jurij Modic					Republic of Slovenia
tel: +386 61 178 55 14			Ministry of Finance
fax: +386 61  21 45 84			Zupanciceva 3
e-mail: jurij.modic_at_mf.sigov.mail.si	Ljubljana 1000

Received on Tue May 27 1997 - 00:00:00 CDT