Return a range of dates between 2 given dates

Moderator: NorbertKrupa

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Return a range of dates between 2 given dates

Post by id10t » Fri Sep 13, 2013 8:58 am

Hi!

>> which option would you recommend for best performance?
"EXPLAIN" and "\timing" - should help you to get answer.

I prefer the second option:
1. As I pointed above - I think TIMESERIES has a bug and I don't trust any more to it(performance - out of scope, I need to be sure in what I use).
2. Second option more flexible and powerful, while 'interpolated value' calculated from function 'row_number()' and you can play with it.
3. And finally I believe(didn't measure it): usage user table(not a system, as in example) as iterator much more faster than TIMESERIES. System tables are mostly VIEW based on DC tables and it takes a time to build a table.

Post Reply

Return to “New to Vertica SQL”