Geodatabase with Oracle Spatial performance

Discussion created by gkar68 on Mar 27, 2014
Latest reply on Mar 31, 2014 by gkar68

We are storing data in Geodatabase on Oracle using Oracle Spatial option SDO_Geometry
and consuming that using ArcGIS server 10.2.1

The performance is very slow (we are talking about between one to two million records)

When I loaded the data, I didn't pay attention to create indexes or configure indexes
I just used FME to load data from file geodatabase.

What are the best practices when you use Geodatabase on Oracle with SDO geometry?
Which indexes are being used, the oracle ones, or sde ones?
I am very beginner in the performance issues, because I am mostly a developer.
thanks for any help.
Any help, best practices, guidance, will be appreciated.