[SBD4]

1A) CREATE TABLE CUSTOMERS AS SELECT * FROM SH.CUSTOMERS
1B) SELECT * FROM user_tables WHERE TABLE_NAME LIKE 'CUSTOMERS' - nie ma zebranych statystyk
1C) EXEC DBMS_STATS.GATHER_TABLE_STATS('sbd48','CUSTOMERS');
1D)
1E) 55500/1485 = ...
1F) SELECT column_name, num_distinct AS liczba FROM user_tab_columns WHERE table_name ='CUSTOMERS' ORDER BY liczba DESC;
1G) tam gdzie najwiecej unikalych


2A) CREATE INDEX cust_cust_city_idx ON CUSTOMERS(cust_city);
2B) SELECT * FROM user_indexes WHERE TABLE_NAME LIKE 'CUSTOMERS';
    blevel- INDEX consists OF a Root Block