Karen Can't say for sure without testing, but I suspect that two temp tables with INDEXES will be faster.
Davied "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Saturday, January 2, 2010 11:18 AM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - Temp table or view? 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
