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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/5ab1df66-9325-4b71-b445-45576619654dn%40googlegroups.com.
