Re: what does Grouping column cardinality mean in 10053 trace ?
From: Obivan <djeday84_at_gmail.com>
Date: Tue, 04 Mar 2014 11:32:08 +0400
Message-ID: <53158178.3040202_at_gmail.com>
upd: query run fine after change
Date: Tue, 04 Mar 2014 11:32:08 +0400
Message-ID: <53158178.3040202_at_gmail.com>
upd: query run fine after change
where prod not in ('POS + POS','Низкодоходные
(20-30%)','Среднедоходные (30-40%)','Акционные (<20%)','Высокодоходные(
>40%)')
To /where prod *IN*/
but anyway what does grouping column cardinality means ? for example /Grouping column cardinality [ DEALS_CNT] 1/
how it is translate to:
select count (*),DEALS_CNT from MA_USER.segment_all_1 group by
DEALS_CNT order by 1;
COUNT(*)| DEALS_CNT
----------|----------
1| 6 1| 7 19| 5 132| 4 1273| 3 12581| 2 104902| 1
ps: Histograms are exists and statistics are actual
On 03/04/2014 11:01 AM, Obivan wrote:
> where prod not in ('POS + POS','Низкодоходные > (20-30%)','Среднедоходные (30-40%)','Акционные > (<20%)','Высокодоходные( >40%)')
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 04 2014 - 08:32:08 CET