Linked (Sybase) Server (via ODBC) S-L-O-W

Linked (Sybase) Server (via ODBC) S-L-O-W

Post by Tom Dierick » Tue, 13 Apr 1999 04:00:00

ANY views (or queries in DTS) connecting to a Linked Server (via ODBC) are
painfully S-L-O-W!!! It's as if the linked tables have no indexes!! Yet,
from within Ms-Access, the linked tables (via ODBC) to the Sybase database
are quick??

We use ODBC to connect to a Sybase System 11 Data Warehouse. I THOUGHT we
wanted to migrate to SQL Server 7.0, but not if it's going to be like this!!

For example,
WHERE IDNUM = '555555555'

freezes SQL Server up, But:

WHERE IDNUM = "555555555"

in MS-Access retrieves the correct record in 2 seconds!!!!!


Linked (Sybase) Server (via ODBC) S-L-O-W

Post by Gert Draper » Tue, 13 Apr 1999 04:00:00

Use the OpenQuery, that way it will be passed through query and it will use
the index. You are retrieving the complete table to SQL Server and filter on
that side, causing a complete scan on the Sybase side.

The ODBC driver does not allow you to use indexes directly because of
limitations in the OLE DB Provider for ODBC Drivers. If you would use a
native OLE DB Provider towards Sybase which implements the IDBSchemaRowset:
INDEXES rowset and IRowsetLocate on base table rowset.

Cohesion Software
No live without an edge.


1. 22411-NC-Raleigh-PC-UNIX-Windows-Windows 95-ORACLE-PeopleSoft-PeopleTools-Intran

******** VISIT US AT ***********
Company    : Technisource
Website    :
Job Title  : Programmer
Location   : Raleigh, NC
Job Type   : Contract
Technisource is an innovative and rapidly growing national contract, consulting
and staffing organization Technisource has a long list of satisfied clients and
hundreds of high caliber consultants with rewarding careers in the technical
industry Technisource offers the best solution whether our clients' needs are
for one engineer, a team or a complete outsourcing unit Since 1987 Technisource
has specialized in the technical consulting industry and is the most qualified
resource to turn for your next project Over 600 opportunities are listed on our
website, WWWTSINET for engineers, programmers, designers, technicians and
technical writers

PC (IBM or Compatible) required UNIX, Windows 3x, Windows 95, Oracle,
PeopleSoft HR, People Tools, and Intranet required PS 60 desired DURATION 6 - 9

Travel Required          :None
Educational Requirements :None
Required Skills
* PC
* Windows  Version: 3.x
* Windows 95
* PeopleSoft
* PeopleTools
* Intranet
Contact Information:
Reference : OR10002

1901 NW 62nd St.,  #401

Ft. Lauderdale, FL 33309

Phone: 800-940-1111 EXT 237
   -   -
Fax No: 888-290-2990
***********************  ****************************

                The On-Line, On-Target Job Finder for Computer Professionals

** Post Your Resume and see results immediately!! ** Always free **
** Post jobs for 30 days for $40, unlimited postings $250/month
** Matching Resumes E-mailed daily
**  Your ads are virtually guaranteed to be seen by jobseekers on the NET' **

                    ** Automatic Posting to **
   ** Yahoo            ** Americas Job Bank    ** Career City
   ** HeadHunter.Net   ** Classifieds 2000     ** Usenet Newsgroups
               *** OVER 20 MILLION HITS/MONTH COMBINED !!! ***

***********************  ****************************

2. PLEASE... I risk the dismissal :(

3. Table structure, Joins & Performance. Help!!

4. Connect OS/2 via ODBC to MS SQL Server 6.5

5. Array in PL/SQL

6. Connect OS/2 via ODBC to SQL-Server 6.5

7. Any tool manage MDB without Access?

8. Question: SQL Server 7/2000 with linked server via ODBC

9. Performance Monitoring Nt server via Win2000 WS

10. Linking to Access table via BDE via ODBC

11. SQL Server 6.5 WS on NT4 WS

12. MS SQL Server Linked Server And Sybase ODBC Driver