Skip to Content
0
Former Member
May 29, 2008 at 10:25 AM

WHY select with join work faster than view (oracle)

16 Views

Hello abapers.

We have created view based on 3 tables.

And the same code with joins...

And It had been found out that select with joins work 2,3 times retrieve data faster than the same code with view...

But If we use the same selects (with and without view) via sql*plus the rates almost the same.

Regards,

Vladimir