The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
order by desc performences best practic
Projection sort order do not support order by desc , my use case is simple data out query, no aggrigation but with order by desc on first column of the projection , we have vertica in one host setup , 100m records table the query do not have amy joins .its a simple flat query that scan last week data rang do some distinc on inline query and bring top 2k records in desc order , when i remove the desc from my order by the query is very very fast (9sec) however using desc the query run about 120sec, the execution plan of the none desc test shoe no order , where the one with the desc order show sort stage , what are the options her ? this is 8 core node and we target it to small customers ,we still need the abiliys to provid desc order result on top of a time range on 100m table with resonable timing. Asc order work very goodddddd