Re: Function Based Index
- From: Purav Chovatia <puravc@xxxxxxxxx>
- To: "Tefft, Michael J" <Michael.J.Tefft@xxxxxxxxxx>
- Date: Thu, 20 Sep 2012 15:22:32 +0530
:)
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
Other related posts:
