We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Quesiton on optimization ratio in DBD results — Vertica Forum

Quesiton on optimization ratio in DBD results

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file