Subject Re: Stumped on SQL Indexing/Bad Plan-ing
Author red_october2009
Here is some further info:

I have been experimenting by eliminating JOINed tables, and fields that pull from tables in the JOIN.

If I pull back only fields from s then the execution time is fast. As I add VARCHAR() fields from the JOINed tables, execution slows, but is still acceptable (< 2 seconds).

However when I add BLOB SUB_TYPE 1 fields from the JOINed tables, it kills the response time... up to 9 seconds.

Pulling back BLOB fields seems to be the hold up. However, I need those fields. Is there a way to make the blob fields in the query not so damaging to response time?