>> When no index in books: Singleton >> 22 sec Cursor >> 2 sec.
If there is no index on the table you would create a table variable with a suitable index and loop through that - this is presumably what the cursor does. See my previous post starting "What do you think a cursor is?" And my signature.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.