[SQL] emulating sub-queries and search prformances

[Ruslan Zasukhin]

on 3/30/03 7:48 PM, Antoine Beyeler at globule at vtx.ch wrote:

>>> UPDATE table SET mark = false WHERE mark = true
>> 
>>     I think better just "UPDATE t SET mark false"
>>     you avoid search.
>> 
> 
> 
> According to some preliminary test with ViSQL, the "WHERE mark = true"
> is much faster if only a few record are marked (like a tenth of the
> total rec count), and this is a correct assumption in my case.

Ok, agree

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------