Query 'jake.jacobson' would require post-processing ...

[mjacobson]

= would be safer but a lot slower to go through 100k + of records.

[mark]

Not with an index (regular, not metamorph).

[Kai]

Not with a regular index on userid; should be somewhat faster than with Metamorph. Presumably userid values don't get very large (more than a KB or so) correct?

create index useridIndex on janesMasterLogs(userid);

UPDATE janesMasterLogs ... where userid = 'jake.jacobson';


Then you also avoid any Metamorph syntax issues, like a leading +/-/= sign for set logic, etc., or sub-string match issues, etc. Exact char-for-char match with =.

[mjacobson]

Thanks, that is much faster with the correct index built.