Buddy: Marc's original email said that he originally dropped and recreated the temp table each time and it made no difference in speed, his users were still complaining.
Karen > Marc > > That is why I’m saying drop the temp table and then recreate each time > you want to add different rows instead of del rows .. > > > > Projecting the table where count = 0 creates the table without any rows. > It is a lot faster then trying to create the table and add the rows at the > same time. I believe doing an insert instead of a project or append seems > faster. > > > > Buddy > > >
