[Labs-l] Not seeing any indexes

Sat Aug 29 14:18:44 UTC 2015

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 <phoenixoverride at gmail.com> 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 <huji.huji at gmail.com> 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
>> Labs-l at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/labs-l
>>
>>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20150829/4e16dc71/attachment.html>