philipp.zedler(a)tu-berlin.de wrote:
Hallo,
I'm working with the very huge mysql table 'revision' in the database
e.g. enwiki_p and would like to choose keys by hand using 'USE
INDEX(...)', because I think, mysql's choices are sometimes not ideal.
My difficulty is that if I try to do so, mysql claims that the key
__doesn't exist__ although it is displayed when I use 'EXPLAIN' and it
exists according to the database scheme.
Is there something special about the mysql implementation on the toolserver?
Thanks for any hints.
Philipp
enwiki_p in the toolserver is a view, not a table. The index is there in
the underlying table, but you can't select it (a pity).