Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
In Informix I have a partitioned table for performance reasons. One contains the latest data and another the historical data. Also, there is a view which contains data from both.
When I update statistics on the partitioned tables, do I also have to update statistics on the view?
There's no need to update statistics on a view in an Informix database. Indeed, AFAIK, there's no way to do so; statistics are not stored for views.
