Louis Kleiman wrote:

>In my apps, IDs like this are always integers > 0. I often have to add
>what I call hints to queries like this that don't want to use the
>primary key without a little nudging:
>
>update table1
> set total = (select sum(Quantity) from table2 where table2.CustomerID
>= table1.CustomerID and table2.CustomerID > 0)
>
>Maybe it works in your case, maybe not...
>
>Louis Kleiman
>SSTMS, Inc.
>
>

Yes, It enforces the engine to use index on table1 which relatively
small. That is why it does not affect.