There are two database servers and I want to compare their performances.
Both have Windows operating system and and Oracle (10.2.0.4 and 11.0.2) database.
Both are OLAP databases with 15-20 users each. Hardwares are different but I don't have much info about configurations.
There are similar tables on both of them and I used explain plan to compare performance firing same sql queries to exactly same tables. (58M rows, 60 columns).
select * from TABLE and
select count(*) from TABLE
One explain plan shows 00:35:00 and other shows 01:45:00 for time column.
I want to learn if comparing explain plans is enough to compare performances, and if not what shall I do?