RE: Query Hints on Functional Index

2015-07-01 Thread Gerber, Bryan W
an G. From: James Taylor [mailto:jamestay...@apache.org] Sent: Tuesday, June 30, 2015 6:56 PM To: user Subject: Re: Query Hints on Functional Index Thanks for the detail, Bryan. Looks like a bug (as you've concluded) in the hinting mechanism wrt functional indexes. Would you mind filing a J

Re: Query Hints on Functional Index

2015-06-30 Thread James Taylor
Thanks for the detail, Bryan. Looks like a bug (as you've concluded) in the hinting mechanism wrt functional indexes. Would you mind filing a JIRA? FWIW, I tried the following and when only columns contained in the functional index are used, the functional index is used as desired (see below). Mig