i have a huge table which consists nearly 2 million recors in oracle.
when i fire a query for to find the number for record .. it is taking very long time.
Query is : select count(*) from schema.tablename;
what should i do to improve the Performance.
Database : oracle 9.X , windows Machine.