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.

Derived Table Space

2 posts in General Discussion Last posting was on 2012-12-12 16:23:12.0Z
Sid Posted on 2012-12-12 14:36:16.0Z
Sender: 609f.50c895b9.1804289383@sybase.com
From: Sid
Newsgroups: sybase.public.ase.general
Subject: Derived Table Space
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50c89660.60c6.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 12 Dec 2012 06:36:16 -0800
X-Trace: forums-1-dub 1355322976 172.20.134.41 (12 Dec 2012 06:36:16 -0800)
X-Original-Trace: 12 Dec 2012 06:36:16 -0800, 172.20.134.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31593
Article PK: 1158255

Where is derived tables data being stored during query
processing? Is it in data cache or procedure cache or in
tempdb?

Thanks.


Rob V Posted on 2012-12-12 16:23:12.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Derived Table Space
References: <50c89660.60c6.1681692777@sybase.com>
In-Reply-To: <50c89660.60c6.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50c8af70$1@forums-1-dub>
Date: 12 Dec 2012 08:23:12 -0800
X-Trace: forums-1-dub 1355329392 172.20.134.152 (12 Dec 2012 08:23:12 -0800)
X-Original-Trace: 12 Dec 2012 08:23:12 -0800, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31595
Article PK: 1158290


On 12-Dec-2012 15:36, Sid wrote:
> Where is derived tables data being stored during query
> processing? Is it in data cache or procedure cache or in
> tempdb?
>
> Thanks.
>

It takes the form of a worktable; this lives in the temporary database
for the sessions (tempdb by default).

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------