Parameters in view

From: Julian Kooiker <julian_at_kooiker.org>
Date: Mon, 2 Jul 2001 00:37:05 +0200
Message-ID: <fDN%6.149236$qM3.18028774@news.soneraplaza.nl>

Hi,

I am having a big problem with Oracle. We use WebDB in our company to make reports. Now the queries in WebDB can't be that large, so I created a view for a big query. Now the query takes way too long to execute, because a view fetches its results first and then webdb filters the date (with parameters). Because it takes too long webdb generetes a time-out and customers don't see results.

If I use the source of the view as a query and give as a parameter for example customer_id = 2 than the query is very fast. It would be nice, or essential to have parameters within the view itself. But is that possible? Or are there any other ways to do this?

Please help!!!!

Julian Kooiker Received on Sun Jul 01 2001 - 17:37:05 CDT