I'm pretty new to the world of ORACLE schema design.
We're starting to see our queries slow down as we are
increasing the number of records in our tables (1 million +).
Currently we've got no indices applied to the tables.
I'm trying to figure out the best indexing scheme to apply to this schema.
It should be pretty straight forward.
I've got a basic schema (which I've attached below).