A new version of the freeware tool Caché Monitor is released. With the new SQL Scanner can you check FK-Constraints for supporting index to find potential performance bottlenecks. The SQL Scanner also checks cached queries to find JOINs without index. With the hyperlink navigation in the SQL Editor you can jump fast direct during SQL writing to metadata details of the selected table.
The article continues at http://www.cachemonitor.de