>In addition to what Dragan told you,
>You should also learn about concept of preprocessing report output
>into cursors, rather then using native tables for reporting.
>
>If you are using native tables to do your reports and you add index every time you need to write report - your databses will become mess over period of time.
Make that period less than a week :).
OTOH, you were right on cue... that was exactly the thing I wanted to say next, just didn't want to confuse the originator with two different approaches in the same message. Easy does it, or... "how did Lala cut a cat's tail?" "a centimeter a day, so it hurts less".