Re: Oracle Designer 2.1.2: Don't have statistics on CG_REF_CODES!
From: Roy Brokvam <roy.brokvam_at_conax.com>
Date: Mon, 8 Jan 2001 12:03:33 +0100
Message-ID: <a8h66.13042$v46.395351_at_news1.oke.nextra.no>
Date: Mon, 8 Jan 2001 12:03:33 +0100
Message-ID: <a8h66.13042$v46.395351_at_news1.oke.nextra.no>
It turns out this is registered as bug #1158144.
The workaround is:
- create a view based on the cg_ref_codes table which uses a hint to force index instead of doing a full table scan. /*+ first row */
- analyze table cg_ref_codes delete statistics
(Thanks to Oracle, Ashok CG)
-- Roy BrokvamReceived on Mon Jan 08 2001 - 12:03:33 CET