Blogs about: Query Tuning
Featured Blog
PostgreSQL substring search
As most of you have probably discovered there is no nice way to do substring search in PostgreSQL however where’s a will there’s a way. The following post is about overcoming this limit, a… more →
<(-_-)> on PostgreSQL
Gila Monster on Estimated vs. Actual Row Counts
scarydba wrote 2 months ago: I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s j … more →
LaRock on Monitoring
scarydba wrote 2 months ago: Since I just spent a bit more than half of my 24 Hours of PASS presentation on tuning queries talkin … more →
Execution Plan Compile Termination
— 14 comments
scarydba wrote 4 months ago: Recently I’ve been seeing a lot of people with bad execution plans, desperately trying to tune … more →
How SQL Server Index Statistics works - Part 2
namwar wrote 1 year ago: In my last article, How SQL Server Index Statistics works – Part 1 I described the concept beh … more →
How SQL Server Index Statistics works - Part 1
— 1 comment
namwar wrote 1 year ago: In my last article, Selectivity of a Query and how it affects indexing I discussed the selectivity o … more →
DB2 for z/OS SQL Query Tuning
Admin wrote 1 year ago: Let’s begin with a brief review of the key points from my previous article. Intuitive tuning i … more →
DB2 LUW Performance: Table Read I/O and Overflows
Admin wrote 1 year ago: Understanding Table I/O performance is critically important to properly diagnosing the health and ef … more →
PostgreSQL substring search
— 34 comments
kaiv wrote 1 year ago: As most of you have probably discovered there is no nice way to do substring search in PostgreSQL ho … more →
Worst Performing Queries
— 5 comments
furrukhbaig wrote 2 years ago: I have been looking for a easy way to find worst performing queries without runing Profiler and I co … more →
Decreasing the index size on wide columns
— 9 comments
kaiv wrote 2 years ago: If you have indexes on columns that are quite large but are not used for range scans (greater than, … more →
Faster insert for multiple rows
kaiv wrote 2 years ago: As you all probably know the fastest way to get data into the database is the COPY statement, but th … more →
NOW() vs 'NOW'
kaiv wrote 2 years ago: The following examples explain how postgresql query planner deals with queries that use the current … more →
