Re: Help! Very bad SQL bug in 7.2.3.0.0
From: Chris O'Connell <chrisoco_at_icon.co.za>
Date: 1996/10/13
Message-ID: <326079AF.5DCC_at_icon.co.za>#1/1
Date: 1996/10/13
Message-ID: <326079AF.5DCC_at_icon.co.za>#1/1
Tom Fielden wrote:
>
> Join several tables sequentially like so: a-b-c-d-e
> Put a simple on 'e'.
> Observe that the query runs fast.
> Now put a simple condition on 'a'
> observe that the query is 100 times slower! Sheesh!
>
Are you sure the condition on a does not force the DB not to use
indexes?
Cheers
Chris
Received on Sun Oct 13 1996 - 00:00:00 CEST