Hello.
I'm unable to give you suggestions, because I don't see the whole
picture of your data structure. Please, next time forward your messages
to the list. Chances to receive a good advice are greater. Send
good model of your databases (use 'SHOW CREATE TABLE' to represent your
tables).
Hello.
I'm unable to comment your decision about making a separate table
and how your data will be normalized after it. But, in my opinion,
if you're going to use only one letter for WHERE condition your index
will have a low cardinality (number of unique values) and optimizer
might prefer
Hi,
you should have posted 2 threads ;)
the other thing is that I would like to update to 4.1.x on
my debian sarge. Has anybody done this yet?
do I have to just: apg-get remove mysql ?
and apg-get install mysql-4.1
just "apt-get install mysql-4.1" to get things runs smoothly
(which would un
Hello dear all-mighty list :)
I do run mysql in 4.0.24 and have the following very slow query.
select tbl3.colname from tbl
.. (some left joins)
where
left(colname,1)="{letter}"
the tbl.col has no index nore will it ever get one because auf
the tbl structre. (this would make no sense becaus only