case when oracle mysql,Group by 与 case when 在数据库中查询出来的实现原理？

SQL> set autot on

SQL> set lines 80 pages 50000

SQL> select sum(1),case dummy when 'X' then 1 else 2 end x

2  from dual group by case dummy when 'X' then 1 else 2 end;

SUM(1)          X

---------- ----------

1          1

执行计划

----------------------------------------------------------

Plan hash value: 1232670501

-----------------------------------------------------------------------------

| Id  | Operation            | Name | Rows  | Bytes | Cost (%CPU)| Time     |

-----------------------------------------------------------------------------

|   0 | SELECT STATEMENT     |      |     1 |     2 |     3  (34)| 00:00:01 |

|   1 |  SORT GROUP BY NOSORT|      |     1 |     2 |     3  (34)| 00:00:01 |

|   2 |   TABLE ACCESS FULL  | DUAL |     1 |     2 |     2   (0)| 00:00:01 |

-----------------------------------------------------------------------------

统计信息

----------------------------------------------------------

5  recursive calls

0  db block gets

6  consistent gets

2  physical reads

0  redo size

591  bytes sent via SQL*Net to client

520  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed