Is Oracle Smartscan really effective?
- by Vimvq1987
Oracle is marketing Exadata to our company, and they're focusing on Smartscan, which is, advertised 10x more effective than traditional solution. I don't really understand (and somewhat don't really believe) this solution, because they assume that data is put on separated storage, and no indexes are used, so "1TB data was scanned and only 2MB is returned".
So, I want to ask you: is Smartscan really effective. Is it true solution that greatly improves performance or just a buzzword?
Thank you so much for your experience