Subject | Re: error when add computed |
---|---|
Author | ronaldorezende |
Post date | 2003-04-04T18:38:23Z |
> SELECT COUNT(*) might be okay with Desktop-databases, maybe evenwith
> Oracle or MSSQL, but it should be used rarely (if at all) withIB/FB due
> to the multiple generation architecture -to be
> count (*) is not written somewhere in a header of a table - it has
> evaluated every time you call it and this means that the table hasto be
> scanned totally (which makes it quite slow).I don't know why not use the count in my table. I dont use
the "select *". I only use the computed by column when it's really
necessary.