Home » RDBMS Server » Server Administration » Bug 902521: FUNCTION BASED INDEX
Bug 902521: FUNCTION BASED INDEX [message #370461] Tue, 09 November 1999 12:22 Go to next message
PD
Messages: 3
Registered: November 1999
Junior Member
Hi,
I am trying to use an index I made like so...

where trunc(visit_date) >= trunc(to_date(......

And explain plan says it is always a Full Table Scan.

Oracle says there is a bug called
Bug#902521 8.1.5 RDBMS
Abstract: FUNCTION BASED INDEX ON TRUNC(DATECOLUMN) IS NEVER USED

Does anybody have experience with this or maybe a work around.

Thanks

Report message to a moderator

Re: Bug 902521: FUNCTION BASED INDEX [message #370462 is a reply to message #370461] Tue, 09 November 1999 16:55 Go to previous message
MikeG
Messages: 14
Registered: August 1999
Junior Member
A possible workaround would be to add another column which held the trunc of the date and then index that column

Report message to a moderator

Previous Topic: How to select the latest two rows
Next Topic: writing large records to output files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 02 15:03:03 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.