Generaly speaking, using index for search is almost always(except very small(say 1-10k row dataset or very low index selectivity) faster then fulltable scan search. It very depends on your datasize if this difference matters. I can imagine that selecting from table with ~100k rows would be fast enough event without index.
Do a simple test and post result here ;-) Dne středa 16. listopadu 2016 15:56:17 UTC+1 Tommi Korhonen napsal(a): > > If the database is completely in memory, does creating indexes give any > real speed advantage for searches? > -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
