Hi folks, Iım wondering what (in general) causes a join to use temporary tables and filesorts... More specifically, what can I tune to avoid it? I can give more info about a specific situation if anyoneıs interested. All the docs say is that you are likely to get a ³Using temporary² if you sort on a different column set than the ³group by², but Iım not doing that...something else must be triggering it...
Any ideas? -Partap Davis Syncrasy, LLC
