Optimizing SQL Queries on DB2 for i
When a query slows down, the cause is almost always a missing index or a condition written in a way the database cannot use. Here is how to find out instead of guessing.
Articles tagged #indici — 2 results
When a query slows down, the cause is almost always a missing index or a condition written in a way the database cannot use. Here is how to find out instead of guessing.
Db2 for i records which indexes it would have wanted, one query at a time. Creating them all is the quickest way to slow the database down.