Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
complex joins in timesten cache
User_E16RD
Member Posts: 5 Blue Ribbon
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
Comments
-
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.