General information
Forum:
Microsoft SQL Server
Title:
SQL Server 6.5, ODBC, Tempdb
If this is not the proper area for such a question, someone please let me know. Example: I have a table with 140 rows in my main database that has a column ID that is a primary key. I have also created a table in tempdb with 30 rows that also has ID as a primary keys. I need to do a join between these 2 tables. In isql_w a join runs in a fraction of a second. If I use ODBC in an Access 97 front end with linked tables the query takes two full minutes. I think some type of per row table scan is going on here and I have no idea why. Perhaps one of you Visual Foxpro / sql gurus could help me out here. Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only