Hi Guys,
Now any time you are going for custom sql(feature in cognos where you can write your sql).Do use analytical functions .Me and people from my team for some reaosn always thought they slow down the query and so no one encouraged it .
But since analytical functions are oracle function they are there for improving query performance .Oracle introduced them to be faster
Check this link for analytical function.This guy has writen it well
http://www.orafaq.com/node/55
Now any time you are going for custom sql(feature in cognos where you can write your sql).Do use analytical functions .Me and people from my team for some reaosn always thought they slow down the query and so no one encouraged it .
But since analytical functions are oracle function they are there for improving query performance .Oracle introduced them to be faster
Check this link for analytical function.This guy has writen it well
http://www.orafaq.com/node/55
No comments:
Post a Comment