Re: [sqlite] index optimal?

it could be very nice to have a tool going through a bunch of queries, giving all the optimal indices... nothing to do with a brain, it is something that can be produced automatically. the final decision on to create them or not is belong to the implementer (the brain) I know that I would be

Re: [sqlite] index optimal?

Hi, many thanks for your answer, I just think that it could be useful to know if an index is optimal or not, kind of a tool that could give you the best index for speed up a query. Many thanks, Sylvain On Tue, Nov 3, 2009 at 2:52 PM, Griggs, Donald wrote: > Hi

Re: [sqlite] index optimal?

On 3 Nov 2009, at 7:33pm, Sylvain Pointeau wrote: > I just think that it could be useful to know if an index is optimal > or not, > kind of a tool that could give you the best index for speed up a > query. Your brain. A simplified explanation on how to decide what indices you need

Re: [sqlite] index optimal?

Hi Sylvain, Regarding: can you describe an output of a "explain"? ==> A very short answer could be that, in the output of EXPLAIN QUERY PLAN "If you see the name of an index, then that index is used." Regarding: is there something to tell us the best index to have for a specified