FROM DOC D
  JOIN GOODS_GROUP G ON (G.ID = D.GID)
  JOIN CUST_GROUP C ON (C.ID = D.CUST)
  WHERE D.YY =  2004  AND C.PID = 'U7' AND G.PID = '4EJ'

Query Time
------------------------------------------------
Prepare       : 16,00 ms
Execute       : 28 438,00 ms
Avg fetch time: 28 438,00 ms

Memory
------------------------------------------------
Current: 6 137 620
Max    : 13 684 720
Buffers: 2 048

Operations
------------------------------------------------
Read   : 1 578
Writes : 16
Fetches: 28 074 203


Enchanced Info:
+--------------------------+-----------+-----------+---------+---------+---------+
|        Table Name        |   Index   | Non-Index | Updates | Deletes | Inserts |
|                          |   reads   |   reads   |         |         |         |
+--------------------------+-----------+-----------+---------+---------+---------+
|                       DOC|     37259 |         0 |       0 |       0 |       0 |
|                CUST_GROUP|   6988632 |         0 |       0 |       0 |       0 |
|               GOODS_GROUP|      1302 |         0 |       0 |       0 |       0 |
+--------------------------+-----------+-----------+---------+---------+---------+

  SELECT
  SUM(CASE WHEN D.MM =  1  THEN SALE_A ELSE  0  END),
  .......
  SUM(CASE WHEN D.MM =  12  THEN SALE_A ELSE  0  END)
  FROM DOC D
  JOIN GOODS_GROUP G ON (G.ID = D.GID)
  JOIN CUST_GROUP C ON (C.ID = D.CUST)
  WHERE D.YY =  2004  AND C.PID = 'U7' AND G.PID = '4EJ'

  SELECT
  COUNT(*)
  FROM BREND_SALE D
  JOIN GOODS_GROUP G ON (G.ID = D.GID)
  JOIN CUST_GROUP C ON (C.ID = D.CUST)
  WHERE D.YY =  2004  AND C.PID = 'U7' AND G.PID = '4EJ'