>Hi,
>
>I have an application with almost 70 tables and 130 views. Is there any "automated" way to see if my views are fully optimized ? I really don´t want to chech one by one.
>
>Regards,
You could write a routine that loops through the views (use ADBOBJECTS) and USES them, checking the output of SYS(3054,11). Not automatic, but probably as close as you will get.
Erik Moore
Clientelligence