On 19 Oct 2007, at 17:23, Alexandre Benson Smith wrote:

> Do you have an index on "zip_codes"."Zip" ?
>> CREATE INDEX "_tidx_128_31a" ON "vw_ExportForTableau
>> $" ("Offered_dt");
>> CREATE INDEX "_tidx_128_22a" ON "vw_ExportForTableau$" ("Main Type");
>>
>> Any ideas on why this is so much slower?
>
> No indices used neither for the JOIN or the WHERE clause.
>
>> Could it be the float field
>> used for the join?
>
> I don't think so, but maybe I am wrong...
>
> I suggest you to double check if there is an active index on the
> zip table.

That was it. For some reason were not indexing dimensional floating
point columns. This only showed up when we copied data out of Excel
because Jet does not have integer columns. Big ole dope slap for me...

This is what happens when you post while heading out the door on a
Friday afternoon! Many thanks to all the folks who spent the time to
untangle my stupidity.
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html