Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    12

    Unanswered: Set Timing+urgent help needed

    One of my client give the output of
    set Timing on Command as


    Elapsed: 00:01:85.32


    Now it difficult for me to understand what does it mean

    Does it mean 1 minues 85 Seconds 32 Milliseconds


    OR

    Does it mean 1 seconds 85 MilliSeconds 32 CentiSeconds


    Please help in understand what is it ??


    Regards
    Mahesh
    Regards
    Mahesh
    Senior DBA
    Calypso Technology

  2. #2
    Join Date
    Aug 2003
    Posts
    1

    Question Re: Set Timing+urgent help needed

    I have exactly the same question. Did you get an answer to this?

    sjd

    Originally posted by palanmahesh
    One of my client give the output of
    set Timing on Command as


    Elapsed: 00:01:85.32


    Now it difficult for me to understand what does it mean

    Does it mean 1 minues 85 Seconds 32 Milliseconds


    OR

    Does it mean 1 seconds 85 MilliSeconds 32 CentiSeconds


    Please help in understand what is it ??


    Regards
    Mahesh

  3. #3
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    1: Set timing on
    2: execute reasonably complex query which will take some seconds or more
    3: look at watch
    4: wait for query to finish and note reported time
    5: look at watch again

    Result, Hours:minutes:seconds.hundredths



    Cheers!
    Bill

Posting Permissions

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