Re: counting query

[John Meyer <john(dot)l(dot)meyer(at)gmail(dot)com>]

Joris Dobbelsteen wrote:
>>
>> CREATE TABLE attendance
>> (
>>  attendanceid serial primary key,
> 
> Why you have this??? You already have (entered,timeperiod,studentid)
> that you can use, since that must be unique too. Try to avoid surrogate
> keys as much as possible (it really increases performance and
> ease-of-writing for complex queries!


Correct me if I am wrong, but wouldn't a simple number be a lot easier
to look up than a composite key?