Viewing 5 posts - 1 through 6 (of 6 total)
Hi again,
i've reconfigured the indices and it works great! Thanks for your suggestions...and yes I'll redesign the poorly normalized table 😉
Bye, Tobi
May 29, 2008 at 2:55 am
You're right, I already considered splitting up this table, but I was afraid that I can't query the data for each separate column with a single SP -> would yield...
May 29, 2008 at 1:04 am
GilaMonster (5/29/2008)
Then I revise my suggestion - normalise your table.You've got a very unnormalised design which will make it hard if not impossible to create covering indexes.
Thanks, but what do...
May 29, 2008 at 12:45 am
Here are the defs for the table and for the indices. The problem is, that I'm using a SP with dynamic sql to dynamically change the sql statement to query...
May 29, 2008 at 12:28 am
Well, you're right! There's a difference - but why?! He should use the same index, shouldn't he?!
May 29, 2008 at 12:13 am
Viewing 5 posts - 1 through 6 (of 6 total)