April 24th, 2004, 10:20 AM
|
 |
SQL Consultant
|
|
Join Date: Feb 2003
Location: Toronto Canada
|
|
my crystal ball is down at the moment (it runs on windows xp) so i'm taking a shot in the dark here, but i'm guessing that your gefloogle table's secondary index is not going to yield good join conditions with the perplotzin table
what i usually do in this situation is a quick google search for the error message
look at this gem i found: http://doc.ddart.net/mssql/sql2000/...vtools_7twy.htm
(doesn't this look like something lifted off a microsoft web page? yes indeedy-do, it sure does)
Quote: Unable to recommend indexes because the query did not reference any tunable tables. This problem was caused by at least one of the following scenarios.
* The query did not reference any tunable tables.
* The query has a syntax error or is invalid.
* You are working in the wrong database.
* You are referencing a temporary table. |
isn't that a kicker? you have problem X, and the first scenario that could be causing it is that you have problem X
yup, that sounds like something microsoft wrote
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
