I have a great problem with performances of my database, on the SQL request:
select t_test.doc_id, t_test.f_num_centre, t_test.f_num_candidat from
t_test, doc where t_test.doc_id=doc.id and doc.docsubset_id=2000077392
The doc table has 36.000 rows, and t_test the same. There is an index on doc
(docsubset_id) and an index on t_test (doc_id). There is others index too.
When I send this request, I must wait for about 45 sec. before the results
The server is a BI-PII 266, and there is about no activity on the database
neither on the server.
When I was using this request under MS-SQLServer (v6), the wait time was
What's wrong ?
Thank's a lot
In response to
pgsql-novice by date
|Next:||From: David Olbersen||Date: 2001-04-25 16:43:05|
|Subject: Re: SELECT performance problem on a join|
|Previous:||From: Paul Tomblin||Date: 2001-04-25 00:27:37|
|Subject: Re: Re: BETWEEN clause|