explain plan rows
时间: 2023-10-30 10:05:18 浏览: 42
"Explain plan rows" is a term used in database management systems to describe the number of rows that will be accessed or processed by a particular query or operation. The "explain plan" is a feature in most database management systems that allows users to see how the database will execute a specific query or operation.
When a user runs a query, the database management system generates an execution plan that describes how the query will be executed. This plan includes information about the tables and indexes that will be accessed, the order in which they will be accessed, and any filters or joins that will be applied.
The "rows" in "explain plan rows" refers to the estimated number of rows that will be retrieved or processed by each step in the execution plan. This information can be useful for optimizing queries, as it can help users identify which parts of the query are most resource-intensive and where performance improvements can be made.