How to tune?

Last Post 18 Jun 2002 07:51 AM by debasish. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
debasish
New Member
New Member

--
18 Jun 2002 07:51 AM
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
You are not authorized to post a reply.

Acceptable Use Policy