[MonetDB-users] temporary tables
Hi,
How do temporary tables behave? Are they only stored in memory or are they written to the disk too like normal tables?
What performance should I expect from using "create temporary table..." and then querying it in comparison to having a nested query?
Thanks.
On Tue, Nov 24, 2009 at 02:04:15PM -0800, Alex Bo. wrote:
Hi,
How do temporary tables behave? Are they only stored in memory or are they written to the disk too like normal tables?
What performance should I expect from using "create temporary table..." and then querying it in comparison to having a nested query?
Temporary tables are if needed written to disk. Performance all depend on the queries. If the nested queries can be properly optimized then they should perform better than temporary tables. When lots of work goes in to the query filling the temporary table then the later may indeed be faster.
Niels
Thanks.
-- View this message in context: http://old.nabble.com/temporary-tables-tp26504075p26504075.html Sent from the monetdb-users mailing list archive at Nabble.com.
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Alex Bo.
-
Niels Nes