Subject | RE: [ib-support] selecting max date |
---|---|
Author | Russell Eva |
Post date | 2000-12-22T07:05:44Z |
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
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