AW: Bad performance in a OR query

> Von: Michaël Fernandez wrote: > I'm working on the usage of MaxDB in the RT System > (http://bestpractical.com/rt/). > I'm using MaxDB 7.0.5.19. > I obtain really bad performances on some queries. > > This is the part of a query which is not well using indexes: > SELECT main.id > FROM Groups m

Bad performance in a OR query

Hi, I'm working on the usage of MaxDB in the RT System (http://bestpractical.com/rt/). I'm using MaxDB 7.0.5.19. I obtain really bad performances on some queries. This is the part of a query which is not well using indexes: SELECT main.id FROM Groups main, ACL ACL_1 WHERE ((ACL_1.PrincipalId = ma