Re: auto_sample_size doing full table scans
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 24 Apr 2013 12:15:03 -0600
Message-Id: <30A3ABA1-AE34-4F44-849C-64B3FAD42578_at_centrexcc.com>
See https://blogs.oracle.com/optimizer/entry/how_does_auto_sample_size On 2013-04-24, at 11:59 AM, Jeffrey Beckstrom wrote:
Date: Wed, 24 Apr 2013 12:15:03 -0600
Message-Id: <30A3ABA1-AE34-4F44-849C-64B3FAD42578_at_centrexcc.com>
See https://blogs.oracle.com/optimizer/entry/how_does_auto_sample_size On 2013-04-24, at 11:59 AM, Jeffrey Beckstrom wrote:
> I am running the below code snippet and it seems to do a full table scan rather than sampling. Sample size and num rows are equal. Any ideas why. This is 11.2.0.3.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 24 2013 - 20:15:03 CEST