I see no measurable improvements creating another index over both columns (LEFT,RIGHT) btw. I already need index for LEFT and RIGHT individually. Also you have to consider the column order when creating and index that spawns over several columns, depending on the data. Ie. have to most restrictive first etc. More indexes increases insert-time.
If my table had 1000M instead of 10M rows, maybe the index over several columns will be faster. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
