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.

Problems with joins with remote tables in adaptive

2 posts in Windows NT Last posting was on 1998-01-20 19:45:35.0Z
Jaime Barillas Posted on 1997-12-30 06:50:42.0Z
Message-ID: <34A899C2.CEF2908E@sal.gbm.net>
Date: Tue, 30 Dec 1997 00:50:42 -0600
From: Jaime Barillas <barillas@sal.gbm.net>
Organization: DBA Ahorromet Scotiabank
X-Mailer: Mozilla 4.0 [en] (Win95; I)
MIME-Version: 1.0
Subject: Problems with joins with remote tables in adaptive
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 7
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5330
Article PK: 1081408

Hello Gurus

I'm working with CIS in adaptive server 11.5 for
Windows NT. I have
problems when i do joins between a local table and a
remote one, it's
delay too much.

I want to know that i can do. Both tables have indexes
in the join
columns.

Thank's


Kevin Campbell Posted on 1998-01-20 19:45:35.0Z
Message-ID: <34C4FEDF.D32F3463@gte.net>
Date: Tue, 20 Jan 1998 11:45:35 -0800
From: Kevin Campbell <KCampbel@gte.net>
Organization: Ad Rem, Inc.
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Jaime Barillas <barillas@sal.gbm.net>
Subject: Re: Problems with joins with remote tables in adaptive
References: <34A899C2.CEF2908E@sal.gbm.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 9
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5284
Article PK: 1081363

Jaime

Have you looked at the query plan and the generated SQL for the remote
server? I've so far had very good luck using this feature. It's worth
making sure that statistics are updated on both servers - I believe you
can update stats on the remote tables too.

I'd be curious as to what a showplan reveals.

Kevin