Designing for Multi-Platform Databases: A SME’s Perspective
When building products that interact with multiple database platforms, the complexity can be both a challenge and an opportunity. For
Read More
Making Technology Bulletproof
sql
Full table scan runs way slower today!
Every so often a DSS query that usually takes 10 minutes ends up taking over an hour. (or one that
Read MoreRight Deep, Left Deep and Bushy Joins in SQL
What is right deep verses left deep? Good question. In join trees (not VST) the object on the left is
Read MoreCURSOR_SHARING : a picture is worth a 1000 words
Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause
Read MoreFinding the slowest SQL execution of the same query
When running the same query multiple times, several questions come to mind: Does the query always execute in the same
Read More