Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Function Based Indexes - Allow queries to use indexes even when you are performing a function on the indexed column.



cachitogoku said...

Hi Tim, you don't specify the values of the parameters
"The QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED parameters must be set "

jreyes@dazasoftware. said...

Hi Tim, you don't specify the values of the parameters
"The QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED parameters must be set "

Jumpers said...

The values are specified above the permissions.

ben said...

i get the error ORA00907: missing right parenthesis when i try to create the following function-based index:

CREATE INDEX UIMSMGR.DEL_DISC_RPT_N2 ON UIMSMGR.DEL_DISC_RPT (TO_CHAR(DEL_CUST_SVCORD_NUM)) tablespace doc_idx;

We are using Oracle 8.0.6.3.0

Please help.

Ben.Buckley@pnmresources.com

Reshma said...

Thank you....!!!
It helped me a lot...!!

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)