On 7/28/05, Chris Travers <[EMAIL PROTECTED]> wrote:
Gnanavel S wrote:>>> vacuum & reindex the department and project table as the planner> expects there are 1060 rows but actually returning nothing.I guess I should have mentioned that I have been vacuuming and
reindexing at least once a week, and
On 7/28/05, Chris Travers <[EMAIL PROTECTED]> wrote:
Hi all;I have a customer who currently uses an application which had becomeslow. After doing some digging, I found the slow query:SELECT c.accno, c.description, c.link, c.category, ac.project_id,p.projectnumber
,a.department_id, d.descri
