Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement