Re: Record row count and execution time into table?

Get the time before the query and get it after the query and diff the
two values. The question is how accurate a value do you want. I say
the minimum query time for your purposes should be one second so you
can just use sysdate. Fractions of a second are meaningless since so
many other factors such as user load at the time of the query and the
need to get consistent read blocks will vary with every execution.

HTH -- Mark D Powell --

.

Relevant Pages

  • ignored words...how to configure
    ... Execution of a full-text operation failed. ... A clause of the query ... Prev by Date: ...
    (microsoft.public.sqlserver.fulltext)
  • Create customizable ranges?
    ... I have a query that calculates the difference ... between a clinic visit date to a sample collection date (Diff). ... simple table to house the range information and somehow link this ...
    (microsoft.public.access.gettingstarted)
  • Re: DateDiff
    ... horizontal display, with all possible diff, aircraft as group ... Aircraft Event Date ... I need a query that provides the difference between each pair of dates ... Aircraft Datedif1 Datedif2 ...
    (microsoft.public.access.queries)
  • diff output
    ... i have two large text-files (output of a database ... query) and i have to do a diff on them. ... updates if there are new lines or deleted lines within a certain range. ... The output of the diff is much bigger then but this does not ...
    (comp.unix.shell)
  • Re: How do Diff?
    ... I was looking to diff at a folder level or the entire project tree for 2 ... I was able to query the differences based on the label and then generate a ...
    (microsoft.public.vstudio.sourcesafe)