Category Archives: Sybase

Some Routine DB Checklist Queries

Posted on January 12, 2017 by tosasan

Mviews Not Refreshed from Last 7 Days: select mview_name from user_mviews where LAST_REFRESH_DATE < sysdate – 7; Total Number of Tables: select count(1) from user_tables where table_name not like ‘%$%’ Total Number of Mviews: select count(1) from user_mviews Total Number … Continue reading →

Posted in Sybase | Leave a comment