[email protected] 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). _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
