Re: what does Grouping column cardinality mean in 10053 trace ?

  • From: Obivan <djeday84@xxxxxxxxx>
  • To: David Fitzjarrell <oratune@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 04 Mar 2014 11:32:08 +0400

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%)')

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2014