Subject Strange query problem
Author Alexander Tabakov
Hi all,

I have a query:

"select hist.cguid from con_discon_info hist"

Table "con_discon_info" has an index on field "cguid".
After query execution I can see in the performance monitor that all of
the reads where non-indexed reads

If I modify the querylike this:

"select hist.cguid from con_discon_info hist group by cguid"
^^^^^^^^^^^^^^^
All reads become indexed ?????

Any ideas.

--
Best regards,
Alexander mailto:saho@...