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 happy
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 Sylvain,
>
>
> Regarding: can yo
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 follows
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
hello,
can you describe an output of a "explain"?
for me it is hard to read and to analyze the output.
is there something to tell us the best index to have for a specified query?
best regards,
Sylvain
On Tue, Nov 3, 2009 at 10:40 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sylvain Pointeau wrote:
> how do we know that we are using an optimal index in a query?
How do you know if you are not?
The point of an index is to avoid visiting every row in a table while
evaluating an expression, so generally the best index is one
hello,
how do we know that we are using an optimal index in a query?
Best regards,
Sylvain
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
7 matches
Mail list logo
