Subject | Strange query problem |
---|---|
Author | Alexander Tabakov |
Post date | 2003-02-12T14:39:46Z |
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@...
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@...