Skip to content Skip to sidebar Skip to footer
Showing posts with the label Sql Execution Plan
Sql Order Of Operations

Sql Order Of Operations

Post a Comment
If I run the following SQL query SELECT * FROM A LEFT JOIN B ON A.foo=B.foo WHERE A.date = 'Ye… Read more Sql Order Of Operations
Db2 Luw 10.5 - How To Force Db2 Stored Procedures To Use Latest Stats For Most Optimized Plan

Db2 Luw 10.5 - How To Force Db2 Stored Procedures To Use Latest Stats For Most Optimized Plan

Post a Comment
We see an issue occasionally. Stored procedure running a SQL runs very slow. Same SQL when run fro… Read more Db2 Luw 10.5 - How To Force Db2 Stored Procedures To Use Latest Stats For Most Optimized Plan
Postgresql Function Execution Plan Cache Principle

Postgresql Function Execution Plan Cache Principle

Post a Comment
Say I have 2 functions using third one. Say function check_permission(user_id) is used by get_compa… Read more Postgresql Function Execution Plan Cache Principle
A Query That Does A Lot Of Reads, But Plan Is Ok

A Query That Does A Lot Of Reads, But Plan Is Ok

Post a Comment
I'm experiencing a strange behaviour in a specific query in the SQL Server 2008 R2. I've go… Read more A Query That Does A Lot Of Reads, But Plan Is Ok
The Same Sql Query Takes Longer To Run In One Db Than Another Db Under The Same Server

The Same Sql Query Takes Longer To Run In One Db Than Another Db Under The Same Server

Post a Comment
I have a SQL database server and 2 databases under it with the same structure and data. I run the s… Read more The Same Sql Query Takes Longer To Run In One Db Than Another Db Under The Same Server
Postgresql Performance Of Ad-hoc Sql Vs Functions

Postgresql Performance Of Ad-hoc Sql Vs Functions

Post a Comment
Is there any difference? I know SQL queries are having their execution plans cached just as good as… Read more Postgresql Performance Of Ad-hoc Sql Vs Functions