Re: Avoiding using the MAX function

[paul smith]

At 09:28 AM 5/25/00 +1000, you wrote:
>Why, what's the matter with using the MAX() function?  Is it anything
>other than the performance load?

No.

And even that might not be a problem.
I think I recall a thread on the SWYNK list
that if ID is a primary key, then MAX(ID)
is a simple lookup.

Then again, I might be remembering something
before it happened.... ;-)

In any event, if I calculate the MAX, I
do so in a VERY small table with one row,
see M$ Q75164 for details.

best,  paul


------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.