I have a general question on performance. (Oracle 11g rel 2 with 20 CPU non-rac)
I created few indexes with the parallel clause. Is this have to do anything in the select statements when the index is used in the select statement or inserts?
To be specific I have a table which is queried too often from the online queries/reports. Will it may create some performance issues when the indexes on the tables are created using the parallel clause? or the index creation has nothing to do with the queries and it is only used to create indexes quickly (using parallel) ?