From: Johan De Meersman Date: December 19 2010 12:11pm Subject: Re: Query Stored Index instead of Group By List-Archive: http://lists.mysql.com/mysql/223834 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=001485e7741c4aa7e40497c24c06 --001485e7741c4aa7e40497c24c06 Content-Type: text/plain; charset=ISO-8859-1 On Sun, Dec 19, 2010 at 3:19 AM, Feris Thia < milis.database@stripped> wrote: > Hi Everyone, > > Is there a way to query values stored in our index instead of using "group > by" selection which will produce same results ? > 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. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --001485e7741c4aa7e40497c24c06--