This discussion is archived
5 Replies Latest reply: Dec 13, 2012 1:00 AM by Purvesh K RSS

Where is give good performace Insert ot greate view?

Ayham Newbie
Currently Being Moderated
Hi All,

I want to know where is faster and good performance.

when i insert data into Global temporary table then used it or
create view and used it.

I have to used maybe 100,000 rows from different tables already est.

Note: during insert to create view i have calculations.
regards
Ayham

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points