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, that's what my forum is for!
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!