Calculation fields - views versus cursors

In the case where a stored procedure uses a cursor which uses a view, and one of the values needed by the procedure is the cursor is a complex calcuation of the view's fields.

I was wondering if it was more efficient to do the calculation in the view definition or the cursor def.

The procedure isn't called that often, perhaps hourly.

Hope you can help,

Iain Received on Thu Jun 19 2003 - 04:13:57 CDT