Dear all, I am looking at an issue with some join forms. I found a couple using fields - in the join criteria - that are not indexed. However since we have over a 100 join forms and would like to check them all, I would like to know if anyone - without reinventing the wheel - has a sql query which looks at the data dictionary tables and tell me which join form(s) is using a field in the join criteria that is not indexed. Environment: ARS7.1/AR SQL 2005 Regards frex
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"