RRinTetons
IS-IT--Management
I'm working on some reporting from our financial accounting system. I need data for a specific range of accounts for last year and the current one. I'll use various date ranges out of those views for the reports I'm doing.
Is it more efficient to declare the views with the overall date ranges as part of the view definition and then query that view for the specific dates or smaller ranges I need, or, should I just declare the view for the entire table without reference to the date range and do the same query for the report? Or, is there really no difference at all as the db engine has to do the same work no matter which way I phrase it?
-
Richard Ray
Jackson Hole Mountain Resort
Is it more efficient to declare the views with the overall date ranges as part of the view definition and then query that view for the specific dates or smaller ranges I need, or, should I just declare the view for the entire table without reference to the date range and do the same query for the report? Or, is there really no difference at all as the db engine has to do the same work no matter which way I phrase it?
-
Richard Ray
Jackson Hole Mountain Resort