This looks more like ad-hoc queries to me -- rather than views. Specifically, views are used for often repeated sql, perhaps with a test on a field or two. Unless these (dynamically generated) views get used a few times (to make it worthwhile constructing a view in the first place), then creating the views is more trouble (and processing expense at the RDBMS) than just running dynamic sql. If it's possible and under your control, perhaps re-think the partitioning of the sysaudits table. Rather than having sysaudits_01, sysaudits_02, etc., you could have a single sysaudits table with a column for "audit number". Then you have a simple query to achieve your required results; instead of multiple unions.