Check out SYS(3054). It can give you more insight into query optimization. --
rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Philip Borkholder Sent: Friday, June 26, 2015 12:50 PM To: [email protected] Subject: Re: Rushmore and JOINs Thank you for the responses: What I find strange though, and the reason I posted, is that the JOIN field DID have an index TAG in the CDX with a TAG name that differed from the field, and the Query was slow. Once I added an additional Index tag, on the same field, with a TAG name that equaled the field, the query ran faster... very strange. -Philip _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn4pr10mb0913da461d01f932af670912d2...@bn4pr10mb0913.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
