Subject Indexes and Joins: Follow-up
Author GreatDayDan
Good Morning!

Thanks for all the help for this question.

I added a "And Bt.ClientBillToId > 0" to "JOIN
CLIENTBILLTO BT ON SO.CLIENTBILLTOID =
BT.CLIENTBILLTOID". That eliminated the natural index
from the plan and speeded things up enormassly.

Again, thanks for the help.

Thanks...Dan'l

=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/