- 3,715,918 Users
- 2,242,907 Discussions
- 7,845,683 Comments
Exadata - Any side effects on smart scan and storage index?
We are using Exadata6 and for our application [OLTP] we have a requirement to use a table with 100 million rows. The table is straight forward with 30 columns of varchar2 data type [no blob/clob]. We dont have any index defined for the table. We are querying this table [100 million rows] with few conditions and we noticed our response is good(with in a sec) and explain plan shows storage full scan. We did a load testing by inserts and updates happening in background and multiple searches concurrently. 5000 searches per 5 mins and we continued this for 15 mins. The response is good even.
Question : Is there any side effects of purely going with storage index - will this have any effects on CPU/Memory. We are in a shared database , will this impact others?