Query Stored Index instead of Group By

--20cf304346c6d6b2600497ba0829
Content-Type: text/plain; charset=ISO-8859-1

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

--20cf304346c6d6b2600497ba0829--

Re: Query Stored Index instead of Group By

--001485e7741c4aa7e40497c24c06
Content-Type: text/plain; charset=ISO-8859-1

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

Re: Query Stored Index instead of Group By

--90e6ba6e8f3cbe979a0497e31a22
Content-Type: text/plain; charset=ISO-8859-1

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


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

--90e6ba6e8f3cbe979a0497e31a22--