Top "Sql-execution-plan" questions

A execution, or query plan, is the breakdown of steps the database engine uses to get a result.

How do I obtain a Query Execution Plan in SQL Server?

In Microsoft SQL Server how can I get a query execution plan for a query / stored procedure?

sql sql-server performance tsql sql-execution-plan
How do I view the Explain Plan in Oracle Sql developer?

I have few SQL queries which has very low query running performance and I want to check the query execution …

sql oracle oracle-sqldeveloper sql-execution-plan
Understanding the results of Execute Explain Plan in Oracle SQL Developer

I'm trying to optimize a query but don't quite understand some of the information returned from Explain Plan. Can anyone …

oracle oracle-sqldeveloper sql-execution-plan
Measuring Query Performance : "Execution Plan Query Cost" vs "Time Taken"

I'm trying to determine the relative performance of two different queries and have two ways of measuring this available to …

sql sql-server sql-server-2005 optimization sql-execution-plan
SQL Server Plans : difference between Index Scan / Index Seek

In a SQL Server Execution plan what is the difference between an Index Scan and an Index Seek I'm on …

sql sql-server sql-execution-plan
How to improve performance on a clustered index seek

I'm trying to improve the performance on a query that is running very slowly. After going through the Actual Execution …

sql sql-server query-performance sql-execution-plan
hash value for sql statement

When we execute any sql statement in Oracle, a hash value is being assigned to that sql statement and stored …

sql oracle sql-execution-plan
How do you interpret a query's explain plan?

When attempting to understand how a SQL statement is executing, it is sometimes recommended to look at the explain plan. …

sql database performance oracle sql-execution-plan
Oracle Execution Plan

I am using Oracle 11g and Toad for Oracle. How can I display execution plan for queries? In Sql server …

oracle toad sql-execution-plan
What is a "Bitmap heap scan" in a query plan?

I want to know the principle of "Bitmap heap scan", I know this often happens when I execute a query …

postgresql indexing sql-execution-plan