The Explain Plan button is fourth position from left top corner in form of ambulance sign on the Editor toolbar. If you do not want to store previous Explain Plan results, disable the option Save previous Plan results in the Toad Options|Oracle|General window Types of index search used or Full table scans Order that Oracle will search and join tablesĢ. The Explain Plan determines the execution plan Oracle follows when executing a specified SQL statement.ġ. It is an Oracle function that analyzes SQL statements for performance issues. This article is for beginners to understandĮxplain Plan in oracle helps to find out the path/cost taken by SQL Query fired on to the Database. Best approachįor performance tuning has been to generate Explain Plan for complex SQL queries and then tune them using hints, add missing joins or rewrite the queries. Its common to encounter issues related to Performance of the custom PLSQL Programs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |