Source query from MetaMatrix results in poor performance due to timestamp criteria being compared to Oracle DATE

Solution Verified - Updated -

Issue

  • Query takes too long to execute
  • Indexes are not being used when using date criteria:
    SELECT * FROM MyTable WHERE DateColumn = {d'2000-01-01'}
    
  • A full table scan is done even when passing date/time criteria to limit results

Environment

  • MetaMatrix Server 5.5.3
  • Oracle 9i, 10i, 11g
  • MetaMatrix Oracle JDBC Driver for 5.5.3
  • Source model with date column modelled as MetaMatrix timestamp
  • Oracle table with date column of type Oracle DATE

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In