e "len"
field of EXPLAIN, then look at the sizes of the fields in the chosen index.
(Add 1 for NULLable fields.)
> -Original Message-
> From: Adarsh Sharma [mailto:eddy.ada...@gmail.com]
> Sent: Monday, September 17, 2012 10:06 PM
> To: mysql@lists.mysql.com
&g
Hi all,
Currently i am doing performance level tuning of some queries that are
running very slow in my slow -query log. Below are the sample of some
queries & the cardinality of indexes :-
--- Below queries take more than 15 minutes to complete on a table
scd_table of size 7 GB
SELECT t0.id, t0.be
