When A SELECT is executed for 1 table, it retrieves records quickly (table has 500,000 records).
When a JOIN is included for 2 tables, it creates a SELECT * COUNT ........ which causes the first page display to go from 3 seconds to 36 seconds.
Trace shows this.
I know everyone will want to know a lot of things, but I just have a basic question:
Is there anyway to prevent the SELECT * COUNT when doing a JOIN?