Tag: database-queries
All the articles with the tag "database-queries".
Oracle IN and EXISTS: Query Notes
This article compares IN and EXISTS through practical Oracle query issues, emphasizing the need to correlate an EXISTS subquery with the outer table. It also records considerations involving NULL, NOT IN, and execution plans.
Thoughts on Improving Database Query Performance
This article considers slow queries on large tables from three angles: SQL quality, table and index design, and table partitioning. These are preliminary ideas; the partitioning approach has not yet been put into practice.