Re: [sqlite] [EXTERNAL] Re: Optimization - don't understand.

On Mon, 5 Feb 2018 15:08:33 + Hick Gunter wrote: > I think you are optimizing the performance of a conceptually inefficient > query. > > If you are looking for a recipe that contains apples, do you read the entire > cook book, checking each recipe for apples? Maybe it is

Re: [sqlite] [EXTERNAL] Re: Optimization - don't understand.

I think you are optimizing the performance of a conceptually inefficient query. If you are looking for a recipe that contains apples, do you read the entire cook book, checking each recipe for apples? Maybe it is much more efficient to look up apples in the index of ingredients and retrieve