Tag Archives: sql performance tuning examination questions

sql performance tuning examination questions

Last updated on December 31st, 2015 at 06:03 pmHere are some of sql performance tuning examination questions 1) following an ANALYZE command, which of the following data dictionary views will contain statistics on the number of rows in a table a dbms_rows b dba_table_rows c dbs_tables d dbs_statistics Solution (c) 2) histograms are useful because they allow the optimizer to have a better idea of how … Continue reading sql performance tuning examination questions »