[hibernate-issues] [Hibernate-JIRA] Reopened: (HHH-6096) H2Dialect should use CACHED option for temporary table creation

H2Dialect should use CACHED option for temporary table creation --------------------------------------------------------------- Key: HHH-6096 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6096 Project: Hibernate Core Issue Type: Improvement Components: core Affects Versions: 4.0.0.Alpha2 Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 3.6.4, 4.0.0.Alpha3 Time Spent: 5m Remaining Estimate: 0h Response from Thomas, answering my question: {quote} I guess I would use 'cached' tables (meaning the data is persisted, and the indexes are persisted), just to avoid out-of-memory in all cases. If it turns out to be a performance problem (which I don't think it will) it could still be changed later on. {quote} {code} create local temporary table if not exists {code} should get replaced with {code} create cached local temporary table if not exists {code}