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

   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-l
Received on Tue Mar 04 2014 - 08:32:08 CET

Original text of this message