Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

What does Execution Time mean as reported by the Interative SQL tool

2 posts in General Discussion Last posting was on 2012-01-26 07:55:42.0Z
Ion F Posted on 2012-01-25 16:40:13.0Z
Sender: 3c8b.4f202e29.1804289383@sybase.com
From: Ion F
Newsgroups: sybase.public.iq
Subject: What does Execution Time mean as reported by the Interative SQL tool
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f20306d.3cf5.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 25 Jan 2012 08:40:13 -0800
X-Trace: forums-1-dub 1327509613 172.20.134.41 (25 Jan 2012 08:40:13 -0800)
X-Original-Trace: 25 Jan 2012 08:40:13 -0800, 172.20.134.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4452
Article PK: 246592

Hi all,

I'm a newbie, just finished installing and I'm experimenting
with some queries.
The Interactive SQL reports an execution time which seems to
have no correlation with reality, for instance a simple
select count(*) where somepredicates takes 5 seconds to
return the one row but execution time says 0.02 seconds. I'm
just trying to make some sense of this


j Posted on 2012-01-26 07:55:42.0Z
Sender: 272f.4f1fcd79.1804289383@sybase.com
From: J
Newsgroups: sybase.public.iq
Subject: Re: What does Execution Time mean as reported by the Interative SQL tool
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f2106fe.71af.1681692777@sybase.com>
References: <4f20306d.3cf5.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 25 Jan 2012 23:55:42 -0800
X-Trace: forums-1-dub 1327564542 172.20.134.41 (25 Jan 2012 23:55:42 -0800)
X-Original-Trace: 25 Jan 2012 23:55:42 -0800, 172.20.134.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4453
Article PK: 246594

It's the time spent by the CPU to process your query, not
including the time you were waiting for other processes,
network etc.

-J

> Hi all,
>
> I'm a newbie, just finished installing and I'm
> experimenting with some queries.
> The Interactive SQL reports an execution time which seems
> to have no correlation with reality, for instance a simple
> select count(*) where somepredicates takes 5 seconds to
> return the one row but execution time says 0.02 seconds.
> I'm just trying to make some sense of this