Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL Linked Server and IRowsetFind
4 views
Skip to first unread message
Jim Burton
Sep 30, 2009, 3:05:02 PM9/30/09
to
We have created an OLE DB Provider for an ISAM database that does not support
SQL Queries but does support indexes and IRowsetFind. When an SQL query
involves an index column, the SQL Server query runs very fast. However, when
there is no index column the query runs very slow if the table has many
records. We cannot figure out how to get SQL Server to use IRowsetFind. Any
suggestions would be appreciated.
--
Jim Burton
SQL Queries but does support indexes and IRowsetFind. When an SQL query
involves an index column, the SQL Server query runs very fast. However, when
there is no index column the query runs very slow if the table has many
records. We cannot figure out how to get SQL Server to use IRowsetFind. Any
suggestions would be appreciated.
--
Jim Burton
Erland Sommarskog
Sep 30, 2009, 6:12:52 PM9/30/09
to
As always, you need to look at the query plan. It will give you some idea
what is going on.
But generally, I don't think you should have too high expectations.
Linked servers is a difficult area, and I doubt that SQL Server has a
repetoire to cover all possible cases about which interfaces that may
be implemented.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
0 new messages