""Sandeep"" <sandeep@...> wrote in message
news:3C4E7CB7.27501.145E55@localhost...

>
> What I meant was to get the data using a stored proc (because the
> queries, for whatever reason, are not using the indices and this is
> slowing the response time) and use it in a view.

Unless it's very complex, I don't see a reason why the indices aren't being
used. Maybe you need to force the recalculation of the selectivity? Or maybe
you expect the indices to be used for sorting? It shouldn't be your case, as
VIEWs don't support the ORDER BY clause.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing