By Range Partitioning a Table's data, will there be any effect on the way a simple DISTINCT behaves?
Try it urself and let us know.... but i dont think it wud effect... Abhay.
funky... "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail." "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
the result will still be distinct, if that's what you mean.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules