Post reply

Indexes related problem in SQL server 2000

  • July 31, 2008 at 1:36 am

    #851035

    See attached queries & execution plans screenshots...

    1.SELECT * FROM EMPLOYEEINFO_INDEX

    WHERE DEPARTMENT ='TP'

    OR DEPARTMENT = 'EAGLE'

    2.SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT ='TP'

    union all

    SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT = 'EAGLE'

    3.SELECT * FROM EMPLOYEEINFO_INDEX (index = TEMP)

    WHERE DEPARTMENT ='TP'

    OR DEPARTMENT = 'EAGLE'

    4.SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT ='TP'

    union all

    SELECT * FROM EMPLOYEEINFO_INDEX (index = TEMP) WHERE DEPARTMENT = 'EAGLE'

  • July 31, 2008 at 1:38 am

    #851036

    total rowcount without any conditions = 3215

    total rowcount when Dept 'Abc' = 81

    total rowcount when Dept 'XYZ' = 297

  • July 31, 2008 at 1:39 am

    #851038

    Unable to see your attachments. Post it once again.

    karthik

  • July 31, 2008 at 1:50 am

    #851042

    hi karthikeyan,

    see my previous post for attachement...

  • July 31, 2008 at 1:55 am

    #851045

    Can you attach it once again ? Because i am unable to see any attachments.

    karthik

  • July 31, 2008 at 2:06 am

    #851052

    See attached queries & execution plans screenshots...

    1.SELECT * FROM EMPLOYEEINFO_INDEX

    WHERE DEPARTMENT ='TP'

    OR DEPARTMENT = 'EAGLE'

    2.SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT ='TP'

    union all

    SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT = 'EAGLE'

    3.SELECT * FROM EMPLOYEEINFO_INDEX (index = TEMP)

    WHERE DEPARTMENT ='TP'

    OR DEPARTMENT = 'EAGLE'

    4.SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT ='TP'

    union all

    SELECT * FROM EMPLOYEEINFO_INDEX (index = TEMP) WHERE DEPARTMENT = 'EAGLE'

    Or see URL...

    https://qa.sqlservercentral.com/Forums/Uploads/image-unavailable.png

    https://qa.sqlservercentral.com/Forums/Uploads/image-unavailable.png

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply