Forum .LRN Q&A: Re: Bad performance in one query

Collapse
2: Re: Bad performance in one query (response to 1)
Posted by Dirk Gomez on 04/08/04 03:02 PM
On which page did you find this query? And how many rows are being returned by this query?

The where clause for the apm_packages looks very "unselective" so it seems understandable that the query optimizer is opting for a table scan.