As far as I know, there are two additional tables with specific indexes for queries with usernames, revision_userindex and logging_userindex. They're described here: https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database#Tables_for_revision_or_logging_queries_involving_user_names_and_IDs
Apart from those, I use the MediaWiki database schema as my go-to place for documentation: https://phabricator.wikimedia.org/diffusion/MW/browse/master/maintenance/tables.sql Cheers, Morten On 29 August 2015 at 09:18, Huji Lee <[email protected]> wrote: > Is there documentation on the indexes used on underlying tables? (Or, how > they defer from default MW indexes) > > On Fri, Aug 28, 2015 at 4:31 PM, John <[email protected]> wrote: > >> Neither. What you are seeing from the shared databases are views. Views >> do not have indexes, however the underlying data does. >> >> On Fri, Aug 28, 2015 at 4:28 PM, Huji Lee <[email protected]> wrote: >> >>> Hi, >>> >>> When I run a query like *SELECT INDEXES FROM revision *or any other >>> table on the labsdb databases (such as enwiki.labsdb) I get no results. Is >>> it because I don't have proper permissions, or because none of the labsdb >>> tables have any indexes? >>> >>> Thanks, >>> >>> Huji >>> >>> _______________________________________________ >>> Labs-l mailing list >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/labs-l >>> >>> >> >> _______________________________________________ >> Labs-l mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/labs-l >> >> > > _______________________________________________ > Labs-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l > >
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
