Re: Index by Date Descending: Ignored

From: <billmil_at_my-deja.com>
Date: Thu, 19 Oct 2000 20:34:59 GMT
Message-ID: <8snltj$k1r$1@nnrp1.deja.com>

> Perhaps this is because the record_create_date may contain null
values...indexes cannot be used to sort columns that may contain null

Thanks for the tip, Hans. I'll definitely try this. The no-index- sorts-when-nulls makes sense, but I hadn't come across that yet.

This has proved much harder than I ever would have thought--simply to build an index in descending date sequence.

bill milbratz

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 19 2000 - 15:34:59 CDT