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
Rownum quiz
-
Here’s a silly little puzzle that baffled me for a few moments until I
spotted my typing error. It starts with a small table I’d created to hold a
few rows...
Acum 2 zile
Niciun comentariu:
Trimiteți un comentariu