Karen, I find the temp table somewhat faster for restricted data sets.
The update of the temp table is only done for the set of data that is
needed for the report.
Albert
[email protected] wrote:
Just want to get opinions on which to use. Let's say that
I'm going to base a report on a temp table. In populating that
temp table, I need an intermediate table/view that will hold
aggregate data. And then I will update the report temp table
based on the linking column.
I have 2 choices. I can create a temp view and do the update
based on the linking column in the view. Or I can create a
temp table, insert the aggregate data into the table, and then
do the update.
Any opinions on which is more "efficient"? I have a tendency to
go the temp table route, but I'm not sure why ... Do you think
either one would be faster? Since they are both temporary I'm
assuming there's no disk storage issues.
Karen
