Depending on the nature of your data, you might consider denormalizing it and splitting it up between 2 tables so that you are no longer performing a self-join. If you see enough of a performance boost with the indexed query it *might* be worth the trouble. You'd really have to do some analysis to see if it's the right choice for you.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment