>Tamar,
>
>Thanks for the response.
>
>Very stupid question, but does that mean that if I'm joining a product master and an invoice history file, that if the invoice history file is on the right side of the WHERE, it would run slower?
>
>In other words, would... WHERE ProdFile.Item = InvFile.Item
>
>be slower than... WHERE InvFile.Item = ProdFile.Item ???
>
>Again, stupid question, but figured I'd ask.

Not a stupid question at all. Assuming that InvFile is much larger than ProdFile, probably the second query would be faster. Until recently, I would have be unequivocal about that, but the Probst article last year (May '99 FPA) showed us that there are some situations where an index can actually slow things down. This example is unlikely to be one of them, since the Item tag of an invoice file should be fairly balanced.


>Also (if I can get a 2nd question in)...any news on an available date for your new book (on Office Automation)?
>

Looks like it'll be out just in time for the New Orleans conference.

Tamar