Forum Stats

  • 3,876,221 Users
  • 2,267,082 Discussions


complex joins in timesten cache

I find that joins are taking long time to return. It is very slow compared to oracle database that has indexes on the tables.

I am wondering what is the benefits of times10 if joins still take time


  • ChrisJenkins-Oracle
    ChrisJenkins-Oracle Member Posts: 3,409 Employee

    Do you have appropriate indexes defined on the tables in TimesTen? Have you updated optimiser statistics for those tables in TimesTen? Can you provide an actual example?

    Joins are typically very fast in TimesTen when things are properly optimised. As for any database, if things are not properly optimised then things can be relatively slow. Putting data in-memory does not mean that you do not also need to apply normal database optimisation techniques such as indexing.