var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Which one is best for sql tunning either stats pack or tkprof and explain plan.If use statspack why.
Thanks in advance
explain plan !
status pack is use for instance level tuning.
You are tuning SQL query by modifying the parameters or hints so you can get the best excution plan. You should be able to see the excution plan, to see the SQL execution statistics and that's what tkprof and explain plan are giving you.
Stick with them if you are tuning SQL queries.
Hope that helps,
OCP - DBA
Latest Oracle DBA forums | Oracle DBA Resources | Oracle Usenet Groups
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors