Introduction to Sql Tuning Sql statements are written to retrieve /fetch data from the database. We want our sql statement to run fast(sql tuning) and provide the results in secs. A poorly designed sql could slow down the entire database operation and bring the entire operation to halt. It is much harder to write efficient […]
sql performance tuning
Oracle Performance tuning Glossary
Here is Oracle Performance tuning Glossary. It is quite a complex and interesting topic. Oracle performance tuning needs thorough analysis and knowledge of all the aspects of Oracle database Autotrace Autotrace is a beautiful tool provided by Oracle for getting the explain plan and execution statistics. You need to know the query and its bind […]