Subject RE: [ib-support] selecting max date
Author Russell Eva
I don't know about the SP being better or worse (at least it is consistent)
but
check the index's on the table and the plan the query uses, also put the 5
year
window into the subquery(if you dont mind trying to work out logic :-)
but proberbly the order by is killing the response
Russell