Optimizing database

Hey all, we permanentely delete records in our call-tables (tables that contain data about the phonecalls. You can imagine that this is a lot every day). Unfortunately the database does not correct the indices (at least this is our impression, because the runtime of reports using this tables become longer and longer, until we manually optimize the tables). We would like to do this optimization automatically every week or every month. Is there a way to do this as a automatical job ? Or is there a function within C/AL ? thanks in advance Stefan Weinreich Billing Analyst

Look at www.expandit.com //Lars

Thanks a lot for this link Lars. Do you have already experiences with this tool ? Stefan Weinreich Billing Analyst

We use it for backing up our database. Works great - no problems so far.