Subject | Indexes and Joins: Follow-up |
---|---|
Author | GreatDayDan |
Post date | 2002-04-08T13:13:33Z |
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/
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/