SQL Guy 1 (4/17/2012)

---

Yes, I know this. But my question is this: for example we have 100 partitions and we need to rebuild index only on 10 of them....

Hi there,

yes I have. If you look at the original post there is an example but I used the wrong example posting value =1 in reality I used 2 and...

Actually yes, even though the highest selectivity is on the other column. The provider only has 5 different values and it is filtered in the index to two. I believe...

Dev (11/17/2011)

---

The key part here being the "equality". Since (as far as I know) NULLs are considered NON Equality this would explain why the index is not being...

SpringTownDBA (11/17/2011)

---

agiangone (11/17/2011)

---

Interesting comment and...

SpringTownDBA (11/17/2011)

---

Evil Kraig F (11/17/2011)

---

Hunh,...

Evil Kraig F (11/17/2011)

---

agiangone (11/17/2011)

---

Hi Kraig,

Table has 400,000,000 records and 1.4M are null but on key_2 having value 2 only 40,000 are null so the percentage is about 50% on...

Ninja's_RGR'us (11/17/2011)

---

My view of index hints is simply that to use it you must somehow think that you're smarter than all the guys at ms combined and all the trillions...

Interesting comment and that could...

p-nut (11/17/2011)

---

Craig mentioned the tipping point, here is an interesting link I found on this: http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Tipping-Point-Query-Answers.aspx

That's about all I can find on this issue. I think you will have to...

I'm sorry, yes what? The actual and estimated match?

Correct the actual plan and the estimated one match.

In one case I did have the "bad" plan showing but execution time was...

Hi Kraig,

Table has 400,000,000 records and 1.4M are null but on key_2 having value 2 only 40,000 are null so the percentage is about 50% on the total but that...

Hi Jared,

No worries, I appreciate the discussion; this is what these forums are for.

Yes on the actual plan (they match).

Yes and No on the actual execution time. In one case...

Hi Craig,

yes actually my_column is the clustered index and the index composite index is aligned (see the partition schema at the end).

I think there has to be a reason why...

Yes Jared, I did try it and it does work but I was trying to understand the reason and also avoid any hints.

Thank you though, very helpful.

Andrea