Re: Query Stored Index instead of Group By

2010-12-20 Thread Feris Thia
Hi Johan, On Sun, Dec 19, 2010 at 7:11 PM, Johan De Meersman 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 > > -

Re: Query Stored Index instead of Group By

2010-12-19 Thread Johan De Meersman
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 fie

Query Stored Index instead of Group By

2010-12-18 Thread Feris Thia
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