Become a fan of Slashdot on Facebook

 



Forgot your password?
typodupeerror

Comment Re:Normalization doesn't exist to save disk space (Score 1) 267

And, uh, I have the pleasure of working now with a huge data warehouse that hasn't normalized status codes, so instead of quickly searching for an integer, the queries run slow as hell scanning char fields. It's not good.

That's a problem that can easily be fixed. Replace the char fields with the int's you so crave, maybe adding any missing indexes (indices?)

Do it once and enjoy the results (and speed) forever.

Slashdot Top Deals

The primary function of the design engineer is to make things difficult for the fabricator and impossible for the serviceman.

Working...