Logically, it should not make any difference.
I mean "count()" does not actually "count" anything.
As far as the syntax analyser determines that it should return the number of all rows,
(no WHERE clause), the engine should be able to get this number directly in the database
where it should be stored.
Any decent database engine must keep somewhere the current record number in every table,
without having to count them. So as far as it is obvious in the _expression_ that all records must be
"counted", it should nor make any difference.
Even good old dBase used to have a function to return directly the number of records in any table, even in non indexed tables.
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
