2010-05-04

FUNCTION BASED INDEX

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 
Publicat de la

Niciun comentariu:

Trimiteți un comentariu

Abonați-vă la: Postare comentarii (Atom)