In Oracle 9i&10G, in order to use function based indexes, you have to set :
QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED
http://www.akadia.com/services/ora_function_based_index_2.html
Savepoint Funny
-
Here’s an example that makes perfect sense if you know how Oracle handles
data locking. It’s one that I thought I’d published years ago, but it’s not
on th...
Acum 2 săptămâni
Niciun comentariu:
Trimiteți un comentariu