[Srivathsana]

Hi Andy,

I would simplify the mentioned query as below :

select count(order_base_gid) from ob_order_base

I am also attaching a screenshot which shows the difference in elapsed time between count(*) and count(column_name).
This difference could become very significant in terms of sql performance when many number of queries are running in the system.It is also a possibility that the queries run for a long time and lock the DB,if run on unindexed tables at peak business hours where the application gets hit with lots of user queries.
A humble suggestion would be to analyse all the queries running in BMs and tune them down.