you can have local temp tables, global temp tables as well as indexed views. always depends on what you want to accomplish.