Thomas Vatter schrieb:
is there a possibility for creating views or temp tables in memory to avoid disk io when user makes select operations?
No need. The data will be available in OS and database caches if they are really required often. If not, tune up the caches and do a regular "pre select". Regards Tino