Advertisement
majczel23000

[SBD] LAB4

Nov 20th, 2018
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. 1A) CREATE TABLE CUSTOMERS AS SELECT * FROM SH.CUSTOMERS
  2. 1B) SELECT * FROM user_tables WHERE TABLE_NAME LIKE 'CUSTOMERS' - nie ma zebranych statystyk
  3. 1C) exec DBMS_STATS.GATHER_TABLE_STATS('sbd48','CUSTOMERS');
  4. 1D)
  5. 1E) 55500/1485 = ...
  6. 1F)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement