Why Updating a View Can Kill Oracle Performance—and How to Fix It

A detailed Oracle case study shows how a seemingly harmless view modification triggered a cascade of performance regressions, how nested UNION ALLs, missing indexes, and optimizer choices prevented predicate pushdown, and the step‑by‑step rewrites—including hints, index creation, and scalar subqueries—that finally restored fast query execution.

OraclePredicate PushdownSQL

0 likes · 13 min read

Why Updating a View Can Kill Oracle Performance—and How to Fix It

ITPUB

Oct 6, 2016 · Databases

How Adding Indexes Cut a 30‑Second MySQL View Query to 2 Seconds

A .NET MVC warehouse system’s MySQL view was taking over 30 seconds to fetch 70,000 inventory records, but by adding a composite index on the dictionary table, removing a UNION ALL, and adjusting view algorithms, the query time dropped to a few seconds, with a stored‑procedure alternative for flexible use.

Entity FrameworkStored ProcedureView Optimization

0 likes · 10 min read

How Adding Indexes Cut a 30‑Second MySQL View Query to 2 Seconds

dbaplus Community

Nov 12, 2015 · Databases

Mastering MySQL View Optimization: Techniques, Limits, and Best Practices

This article explains how MySQL versions up to 5.5 process and optimize views, outlines the exact conditions required for view merge rewriting, compares derived table handling with the SQL standard, and provides concrete test cases to illustrate performance pitfalls.

Database PerformanceDerived TablesSQL

0 likes · 6 min read

Mastering MySQL View Optimization: Techniques, Limits, and Best Practices