Hi all This query select sequence,mem,memaddr,memvalue, memRead from data where mem or irqRequest order by sequence
where mem <-- fast where irqRequest <-- fast where mem or irqRequest <-- very slow create index mem on data(mem); create index irqRequest on data(irqRequest); create index memAndIrqRequest on data(mem, irqRequest); mem and irqRequest columns are boolean any hint? thanks Peter -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/5ab1df66-9325-4b71-b445-45576619654dn%40googlegroups.com.
