Re: Best Practices Question

"NorwoodThree" <norwoodthree_at_my-deja.com> wrote in message news:ba03e2c.0202131124.5080ef0e_at_posting.google.com...

> My opinion:
>
> Fix the tables involved to be identical. Frankly, the workaround
> seems really nuts to me, and fixing the tables seems like much better
> design and less trouble and maintenance.

I agree 100%. Unfortunately, I'm just the DBA. Neither Business Area want's to bite the bullet and let me "change their world, they paid for it after all."
The DBA's have been asked to find the second best alternative. What we came up with right away was the function based index on the UNIX table or using a function on the left side of the equality operator in the where clause. Am I correct that if the NT table is the driving table and I use a
function on the column value of the NT table, then I would avoid a full table scan? Are there any other ideas?

Thanks for your help.

Patrick

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG