DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Diff between cout(*) and count(1)

Threaded View

  1. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    MH, those plans look identical to me. I suspect any difference in the stats is due to one being run after the other (N.B. the number of recursive calls).

    P.S. (added later) I've just noticed that the count(1) is changed to count(*) in the plan!
    Last edited by DaPi; 12-18-2003 at 10:43 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width