Re: Views and partitions and performance

2014-02-11 Thread Stephen Sprague
great questions, Burak. Personally, I had not before seen the "create view ... partition on" construct. Not that that means anything but thanks for bringing bringing out into the forefront! So, yeah, do we have an SME out there that would like to elaborate on this beyond the aforementioned url?

Views and partitions and performance

2014-02-11 Thread Burak Gürsoy
Hi, Some background information: We have a really large base table (~1P) — (lets call it raw_table) partitioned like _mm_dd=2014-02-11/hh=12/flag=1 (or _mm_dd=2014-02-11/hh=12/flag=0) I’m testing creating a view on that table to be able to have a consistent user accessible interface ins