reviewed the indices
reviewed the views
reviewed the tablespaces
rewritten thelast statement on the tablespaces