Materialized view and index?

From: <chuan.zhang_at_customs.gov.au>
Date: Tue, 15 Jun 2004 15:03:52 +1000
Message-ID: <74D7B90CA0FCF64FB2DADCA82F2D9434030FA2D7@auactmcust102.customs.gov.au>

Dear DBAs,

   I know some of you got experience using indexes on materialized view. My question is there is an index on a materialized view, how do I enforce the index being used if CBO doesn't choose the index? I have used the index hint, but it doesn't work for me. When I used index hint, index(table_name index_name), what the table name should be - materialized view name or the table in the query?

Any input would be appreciated.

TIA, Chuan

---

IMPORTANT:

• This transmission is intended for the use of the addressee only and might contain sensitive or legally privileged information. If you are NOT the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error, please notify the author immediately by telephone and delete all copies of this transmission together with any attachments.
• The Australian Customs Service DOES NOT AUTHORISE the recipient to further disclose this email or its contents without permission of the originator.
• Unsolicited commercial emails MUST NOT be forwarded to the originator of this transmission unless prior consent has been given.

  ---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 15 2004 - 00:01:19 CDT