Subject »Ø¸´£º [firebird-support] Re: About update clause's time.
Author Svein Erling Tysvær
--- In firebird-support@yahoogroups.com, "Adam" wrote:
> Are you sure Set? Definitely an ascending index does not help for a
> select max query so FB does not use it in that case, but I think it
> does use it for < and > operations (unfortunately I can not test it
> at this moment). Unless this is new in FB 1.5 and did not exist in
> 1.x?

You're absolutely right, Adam, thanks for correcting me! Though I'm
still puzzled by him needing two minutes for updating an integer in
27000 records. Hopefully, some of your comments will help discover the
cause.

Set