:) This column contains datetime and is a classic case of what Jonathan has demonstrated in his index explosion series. Because of applications' limitations we cannot move from storing datetime to storing only date. One other solution would be to have another column which contains only the date and index that column and then NOT index this column which stores datetime; but I didn't want that additional data unnecessarily. I thought FBI would be simple. Thanks. On Tue, Sep 18, 2012 at 5:18 PM, Tefft, Michael J < Michael.J.Tefft@xxxxxxxxxx> wrote: > > -- //www.freelists.org/webpage/oracle-l