Our one of the tables (table_1) has 26 milion records (almost 1.8 milion every month for last 14 months). Now only index is on PK key. simple Query like selct count(*) from table_1 taking 15 minutes to run. Any suggestion to improve performance. Any link or name of book will be highly appreciated.
Thanks in advance