Hello, guys.
I'm reviewing this again after receiving new info from various sources.
1) People say that our function based indexes are incorrect, instead
of LOWER('XXX') we must use LOWER(XXX), where XXX is name of a column.
2) This particular query we build by hand without using our abstract
interface, so it even don't have any calls to LOWER() function.
So you should try:
1) replace all indexes that has LOWER('XXX'), list of indexes we
create by default is in etc/schema.Oracle
2) create index on Groups(Type, Domain, Instance) instead of one I
suggested before and explain query without any LOWER calls.
On Mon, Jan 21, 2008 at 7:51 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote:
> I'm not that good in oracle's optimizer, but I'm pretty sure that the
> following index will help you:
> CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'), Instance);
>
> Can you add it, generate plan again and sent it to the list, so I can
> check that it really helps in the way I think it should :)
--
Best regards, Ruslan.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
