jolan.mahinay (7/19/2010)unpartitioned table contains about 600 000 rows and a query given to me to test it, its takes about 2 minutes and 50+ seconds, so i tried now the partitioned table to expect that it will goes lower that the other one, now the query time goes to higher it takes about 3 minutes and 42 seconds for the partitioned table.
This is not unusual - partitioning only added overhead in this particular case.
Please trace both queries and check where space is being wasted.
How many rows out of 600K have to be actually accessed to serve the query?
Is there any indexing strategy serving this particular query?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.