Forum Replies Created

Viewing 7 posts - 16 through 22 (of 22 total)

  • RE: The execution of sub queries in a view

    After more thought it strikes me as this is almost a bug in that it would seem that the parser/normalizer should recognize early on that the sub query is not...

  • RE: The execution of sub queries in a view

    Grant, no problem. Thanks for your help in figuring this out. We have a lot of views that will need review based on this and I have a new method...

  • RE: The execution of sub queries in a view

    Grant, it looks like your theory is, on the surface, correct. The query that does not explicitly reference the sub query columns is consistently a little bit faster than the...

  • RE: The execution of sub queries in a view

    Grant, let me know if this is not what you are looking for.

    AVERAGE EXECUTION TIME for query not referencing sub query columns

    Time Statistics

    Client processing time0.0000

    Total...

  • RE: The execution of sub queries in a view

    Just getting back to the thread, got caught in a webex...

    I am running on my local dev box and am running dbcc dropcleanbuffers and dbcc freeproccache before each run. I'll...

  • RE: The execution of sub queries in a view

    Hi Grant, Thanks for having a look at this! It would appear that a lot more is happening when explicitly selecting the sub query columns.The statistics IO output...

    STATISTICS IO for...

  • RE: The execution of sub queries in a view

    Thank you Grant for your reply and help!

    Here is the setup...

    /*VIEW DEFINITION*/

    /*NOTE: VBaseAllUsers accesses the base tables directly*/

    create view VAllUsers as

    select

    VBaseAllUsers.*,

    (

    select count(*)

    from UserStudentAssoc

    where UserStudentAssoc.UserID=VBaseAllUsers.iUser

    and AssocType=1

    and DomainID...

Viewing 7 posts - 16 through 22 (of 22 total)