...
I tracked down several existing SQL queries to see how they were affected by the new indexes. I ran the queries against Dev (with the new indexes in place) and Test (no new indexes in place) and recorded the optimizer cost for each query as reported by the Explain Plan tool.
1. Queries from csf-common-legacy unit tests
...