philipp.zedler@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).