Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Jan 2002 @ 16:20:02 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: SQL Tuning - Spool Space Problem
From:   David Wellman


I'd take out the collect statistics commands. In their current position they're telling the optimiser that the table is empty. When the problem query comes to run, the optimiser has stats which says that the tables are empty (i.e. the tables will be treated as very small). That will very possibly cause a 'less than optimal' (!) join plan. It's a good idea to use stats, I'd suggest that you collect stats for a table after you've populated the table.

I'd still like to see the explain.



Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023