Doh!That's improved the tablescan by a factor of nearly 30 simply by changing the array fetch size, and doing nothing else
Whoa!There are far too many unknowns to uncover before suggesting that parallel query is the only way to speed things up.
See, when pushed a little, you manage to think of five approaches that could improve performance, despite your original statement that parallel query was the only way to speed things up. There are more, of course, but well done.suggesting that parallel query is the only way toThere are far too many unknowns to uncover before
speed things up.
Just because a problem has complex (but
well-structured) rules, does not mean that it cannot
be quantified! Assuming that the large table must be
read from disk, we have:
- Change stripe size
- Change RAID
- Use SSD ; )