Why is it useful?
|Who would benefit from this IDEA?||As a customer I want to be able to identify obsolete views in servers and recompile them. Currently, we use nz_check_views script to do that.|
How should it work?
Purpose: Check each VIEW to make sure it is not obsolete (and in need of rebuilding).
This script operates by issuing the following SQL against each view
The purpose of the "limit 0" is to
What types of actions can cause a view to become obsolete and need rebuilding?
|Priority Justification||We are migrating all our Netezza servers to IIAS|
|Customer Name||Blue Shield of CA|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions