BEGIN
dbms_stats.delete_column_stats(
ownname=>'SH', tabname=>'SALES', colname=>'PROD_ID', col_stat_type=> 'HISTOGRAM');
END;
/
rowlen surprise
-
Here’s a little detail about Oracle’s calculation of
user_tables.avg_row_len that I hadn’t noticed before – and I really should
have noticed it years ago, ...
Acum o zi
Niciun comentariu:
Trimiteți un comentariu