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?

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.