Hi, I have a large table in which I need to find only one matching record from the table. If I put in a LIMIT 1, could that improve performance?
If there is a limit, does the engine stop searching once the LIMIT has been found? Or is the LIMIT applied as a filter after the search has been performed? Thanks, -Adam -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
