[thesite] dean, some oracle things again..

Dean Mah dsmah at home.com
Thu May 17 17:26:43 CDT 2001

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.


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

More information about the thesite mailing list