Re: How are temp tables stored?

In <gtynen.212.0167FBFF@interaccess.com> gtynen@interaccess.com (Gerard Tynen) writes: >Does anyone know how temporary tables are stored in Informix? I have >heard that they are stored in memory if they are small enough, although >it seems to me they would have to write out to disk beyond a certain >size. Still their performance does not seem any better than regular >tables, once they are created and have indexes in place. So I suspect >they are really stored on disk anyway. Anybody know? I am using >Informix 5, but would also like to know how 6 does it, if different. >Thanks heaps They are stored in root db-space on disk because this db-space is used for temporary storing parts of tables. So if you use a scroll cursor the readed lines are also stored in that db-space (on-line). I do not know where these tables are stored in SE. Peter