I am not entirely new to SQL, however in my new position I access as/400 tables through SQL query analyzer. Sometimes, I query directly through the as/400, but there a few issues such as limits on what I can do with the data and it dropping signs from my currency fields. (If my query has anything to do with currency, I have to use SQL)
When I first started my position, the queries did not seem long to take running. However, now it's like pulling teeth sometimes.
As far as I know, there are no indexes on any of the columns, and there is not likely to be anytime too soon (3rd party software). I have tables ranging from 70,000 to 3 million records. And sometimes I have to join on fields that are packed (which seems to slow down to the point of dripping molasses.)
Anyway, I have picked up a few hints (limit columns and rows queried, etc...)
So anyway, bottom line...does anyone have any books they can suggest that are really good at tweaking query/stored proc. performance? Or if not, have any suggestions??
It would be gladly appreciated!!
When I first started my position, the queries did not seem long to take running. However, now it's like pulling teeth sometimes.
As far as I know, there are no indexes on any of the columns, and there is not likely to be anytime too soon (3rd party software). I have tables ranging from 70,000 to 3 million records. And sometimes I have to join on fields that are packed (which seems to slow down to the point of dripping molasses.)
Anyway, I have picked up a few hints (limit columns and rows queried, etc...)
So anyway, bottom line...does anyone have any books they can suggest that are really good at tweaking query/stored proc. performance? Or if not, have any suggestions??
It would be gladly appreciated!!
