Many thanks! Ismo's reply solved the problem, and Tom's reply solved
another one.
Marko
Ismo Tuononen wrote:
select studentid,max(score) from studentprofile group by studentid;
On 20/02/07, Tom Lane <[EMAIL PROTECTED]> wrote:
The optimal index for this would be on studentprofile(studentid,s
Hello,
I'm having a surprising performance problem with the following simple
'highscore report'
select studentid, (select max(score) from
studentprofile prof where prof.studentid = students.studentid) from students;
I have indexes on students(studentid) and studentprofile(studentid).
Row count
