Re: Query Stored Index instead of Group By

Hi Johan, On Sun, Dec 19, 2010 at 7:11 PM, Johan De Meersman vegiv...@tuxera.bewrote: 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,

Re: Query Stored Index instead of Group By

On Sun, Dec 19, 2010 at 3:19 AM, Feris Thia milis.datab...@phi-integration.com 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

Query Stored Index instead of Group By

Hi Everyone, Is there a way to query values stored in our index instead of using group by selection which will produce same results ? Please advice.. Regards, Feris