I'm running an Oracle 12c database with 32gb ram and ~ 1 mln rows by ~ 30 columns. My queries take forever to run if I try to do a join or where without an index. If I create the indexes it finishes in a few seconds.
Could this have something to do with the configuration of the database?
Regards,
Jan Willem