Hi,
When I ran DBD for incremental design, there were following two messages thrown as part of the optimization results. Query 4 is a simple single column select query on a view whereas Query 5 is a query which has three columns selected, of which one is as is column from, a second column using extract function on a timestamp column and the third column is simply count(1). What does Optimization ratio 1 mean? What query types does DBD fail to optimize the query for?
Query optimization results...ent script...
Query 1 optimization ratio or status is 1
Query 4 optimization ratio or status is CANNOT BE OPTIMIZED DUE TO QUERY TYPE
Query 5 optimization ratio or status is CANNOT BE OPTIMIZED DUE TO QUERY TYPE
Thanks, Kharvi
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.