This isn't to say that when queries INSIDE of the stored procedure are using
a WHERE clause that they cannot be optimized. I mean WHERE clause criteria
on a SELECT procedure itself.

Just thought I would clarify since your reaction seemed to indicate
amazement. There's nothing to be amazed about. There is no way the stored
procedure would know how to apply the WHERE clause on its output to whatever
you have done inside of it to derive the output.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Rob Schuff" <rob@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 03, 2002 9:51 PM
Subject: Re: [IBO] Using Stored procedures exclusively


> Well, that's a real shame. guess we'll have to do some testing to see
> performance falls off. We typically have small apps so we may be able to
> get away with it. Is this particular optimization issue getting any
> attention from the FB group or is it too big of an issue?
>
> thanks!
>
> rob
>