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

-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room C0.02/M3.46, phone ++31 20 592-4098 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl