Indexes should be added to automatically on inserts. Rebuilding indexes usually only helps when the B-tree structure becomes unbalanced, IIRC. Run an explain plan on the query and find out where the big hit is. I'll try to look at the configuration and query tonight. Dean Daniel J. Cody writes: > ya, i meant index.. that updated every 5 minutes.. or better yet, a > trigger that rebuilds the index when a an article is updated..