fancy+   Labs SQL Optimizer v1.0 Tools Info · XTools! Hedonil

Running schemas: Normal Wiki · Commons · Wikidata · Centralauth  •  View definitions: Public views  •  Run query online: Quarry  •  Tutorials: SQL-Repo · Help SQL  •  Repo: GitHub ·

SHOW EXPLAIN Mode:   auto   manual Query-base:  

Optimizer result [hide]

Table / Index / View references [hide]

Please check View definitions, especially if you are using archive, revision or logging tables. If there's a conditional for a column - eg: IF((`enwiki...) AS `rev_user_text` - you cannot access the index in the underlying table from this view. In this case, try another one. All "normal wiki's" are referred to enwiki.