This content has been marked as final. Show 3 replies
I have worked with Oracle databases that had 72 tables ranging from 2.5 to 10 million rows, all with SDO_GEOMETRY columns and all indexed with RTree indexes. 2 million is not going to be a problem.
One thing you may want to look into, if you expect your tables to grow, is partitioning your tables and partitioning your spatial indexes. I have very good experiences with partitioned spatial indexs ([url http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_index_query.htm#i1005901]check the documentation for more info).
Thank you all for answers. I have to study more on this topic. We'll try to make partitions on tables and indexes.