The Finder view lets you scan every script in your database. You can combine these options:
Need a refresher on RegExp syntax? A concise tutorial is available at . Regular expression example :
The following RegExp finds every select whose where clause filters on ID:
\bselect\b[^;]*(?<!\.)\bid\b
This helps you quickly spot places where you can replace first(select myTable where ID = searchId) with the faster alternative: record(myTable, searchId) .
How it works step by step :