On Mon, Dec 03, 2007 at 02:31:04PM -0500, Vivek Khera wrote: > having too many indexes is bad, as you have just added a *lot* of > overhead for every insert/update/delete in that you must update all > the extra indexes. > > there is some fine balance in between, which takes a lot of experience > and analysis to find.
And that's why Oracle DBAs make $90K+ a year... Cheers, -- jra -- Jay R. Ashworth Baylink [EMAIL PROTECTED] Designer The Things I Think RFC 2100 Ashworth & Associates http://baylink.pitas.com '87 e24 St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274 Witty slogan redacted until AMPTP stop screwing WGA _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com