count(*) is taking more time in production vs test
Hi Experts ...Need your kind help on what else i can check to improve the simple count query which takes about 4 seconds in production but takes less than a second in test.
Database : 12.2.0.1 April 2021 CPU patch.
TEST:
Production:
So far i collected stats and i see table and index stats are upto date.
Please suggest what else i can do to improve the query performance.