All Forums Analytics
poonam 7 posts Joined 03/06
30 May 2006
partitioning results of query

hi,i want to run this insert..select query.now since the result set is huge, i am running into spool space problems.is there any way by which i can avoid this.some way by which the result set may be partitioned into smaller sets???thanks in advance.

j355ga 100 posts Joined 12/05
30 May 2006

I'd venture to guess you will not need to "partition" your results once you tune the SQL. Suggest you run an EXPLAIN on the INSERT..SELECT and determine where the bottle-neck is in you SQL. This should be your first step in performance tuning.Hope this helps.

Jeff

poonam 7 posts Joined 03/06
30 May 2006

Hi,could you please explain how to go about this 'EXPLAIN'.???thanks a lot

j355ga 100 posts Joined 12/05
31 May 2006

You can find a detailed introduction in "SQL Reference: Data Manipulation Statements" from the NCR website.

Jeff

You must sign in to leave a comment.