It’s a common feature in many SQL IDEs as well. It also lets you analyse existing queries to see if they are inefficient if you’re looking for ways to improve your queries. It shows what kind of operations the database will perform, and some other statistics such as cardinality and cost (which we’ll get into later).Īs someone writing a query, it gives you an idea of how the query will run and shows you if a query is inefficient before you actually run it. What Is An Execution Plan or Explain Plan?Īn Execution Plan (sometimes called an Explain Plan) is a list of steps that the database will take to run your query and give you the results you need. ![]() In SQL Developer, there’s an option called “Explain Plan”. One of the most valuable features for writing SQL queries is seeing how long it will take to run and how efficient it is.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |