data_warehouse_jarir

Praktikum 2

ALTER SESSION SET star_transformation_enabled=FALSE;
EXPLAIN PLAN FOR SELECT /*+ norewrite */ t.calendar_month_desc, p.prod_subcategory, c.cust_city, SUM(s.amount_sold) AS dollars FROM sales s, times t, products p, customers c WHERE s.time_id = t.time_id AND s.prod_id = p.prod_id AND s.cust_id = c.cust_id AND c.cust_city='Ravensburg' AND p.prod_category IN ('Hardware','Photo') AND t.fiscal_year IN (2000,1999) GROUP BY p.prod_subcategory, calendar_month_desc, c.cust_city;
SET LINESIZE 160;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);