mister.magoo (4/22/2013)

---

Sean Lange (4/22/2013)

---

mister.magoo (4/19/2013)

---

Sean Lange (4/19/2013)

---

I had to dig around a bit to find this one. One of our legacy tables replicated from the Main Frame has a table that nobody really knows it is for but...

There is a column ConstantC char(1).

Anyone want to take a guess what value you will find in all 1.2 million rows???

Not only do we have 1.2 million copies of the same value, just using the column is 9 or 10 extra keystrokes than just using the actual constant from the keyboard. :w00t:

Please tell me there is an index on it as well!

No the table is a heap!!! I have been asking around and nobody knows what the table is even used for. 😛

Maybe I will add a clustered index.

Oh, that's a shame, an index on 1.2 million repetitions of "C" would have been sooooo nice 😛