Oracle indexes tip
I recently had the pleasure(?) of optimising a query in Oracle, and discovered that splitting the query into two parts, each returning part of the required results, and then creating indexes to optimise these seperately was a workable strategy. in thi… more »