MySQL Lists: mysql: Re: Query Stored Index instead of Group By

List:	General Discussion	« Previous Message Next Message »
From:	Feris Thia	Date:	December 21 2010 3:19am
Subject:	Re: Query Stored Index instead of Group By
View as plain text

Hi Johan,

On Sun, Dec 19, 2010 at 7:11 PM, Johan De Meersman <vegivamp@stripped>wrote:

> You can't query the index directly, but if you select only fields that are
> in the index, no table lookups will be performed - this is called a covering
> index.
>

Great.. Thanks for the confirmation.

Regards,

Feris


>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel

Thread
• Query Stored Index instead of Group By	Feris Thia	19 Dec
• Re: Query Stored Index instead of Group By	Johan De Meersman	19 Dec
• Re: Query Stored Index instead of Group By	Feris Thia	21 Dec