Tag Archives: sql performance tuning

Oracle Performance tuning Glossary

Comment

Here is the glossary on Oracle Performance tuning. It is quite complex and interesting topics. Oracle performance tuning need through analysis  and knowledge of all the aspect of Oracle database Oracle Parser It performs syntax analysis as well as semantic analysis of SQL statements for execution, expands views referenced in the query into separate query blocks, optimizing it and building (or locating) an executable form of … Continue reading Oracle Performance tuning Glossary »

sql performance tuning

Comment

Sql statement are written to retrive /fetch data from the database. We want our sql statement to running fast and providing the results in secs. A poorly design sql could slow down the entire database operation and bring the entire operation to halt. It is much harder to write efficient SQL than it is to write functionally correct SQL. sql performance tuning can signficantly improve … Continue reading sql performance tuning »