> I'd imagine that all db systems use a full table scan with NOT LIKE. Servers with more advanced optimizers often fall back to doing a full index scan, rather a full table scan for things like this. While still generating a lot of I/O a scan of an index, should require a lot less I/O than a table scan.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
