I've been told that joins are a bit faster than views but my somewhat limited testing on a medium large sized dataset shows the joins being faster by 10-20%.
Anybody have any information for me on this?
Are there differences in how Oracle is configured that would affect this?
Tks for any info. DRE