Well I don't work in a multiuser environment, just single user, and I don't
work with tables that have 4 million records. I bet it takes a while to
even re-index that monster. But I am guessing that whether it's good or bad
design is solely based on who is using it, when and where.
Take care,
Steve