Thanks. Good to know. On Sat, Aug 29, 2015 at 10:32 AM, Morten Wang <[email protected]> wrote:
> 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 > >
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
