[thesite] dean, some oracle things again..

[Dean Mah]

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..