Why don't you test both approaches and conclude?We can't give a definitive answer as it depends on too many unknown factors : table structures and query to begin with, database version, volume of data, is the view/result set meant to be reused multiple times in the process? etc.
Ayham wrote:You never would and so do I, unless I test both the approaches. Compare the execution time, the execution plan.
the requirements for i want to used th data based this view or temporary table.
the story i have maybe 9 tables , i want to query some attribues in this tables. then i want to used that results for another query.
so , must be to create view ot global temp table.
but i don't know which one will be faster in retriving data.