Back in 2007, my third blog entry was about a parallel index building gotcha, a warning about building & rebuilding indexes in parallel. After completing the build, Oracle left the parallel degree in place for that index in data dictionary. Thus, after building a great new index over some weekend, many of your OLTP queries could have picked a parallel plan afterwards! Whenever creating/rebuilding any indexes, I had a habit of writing up both the CREATE INDEX . - Linux, Oracle, SQL performance...
