Same table different performance
We have 2 tables say DBO.Price and DBO1.PRICE in the same database. The DBO1.PRICE is created from DBO.Price thus has the same structure, data, Indexes. Itresides in the same database which means both use the same underlying resources. DBO1.PRICE was created by export dump.
After the copy we Gathered STATS on DBO1.PRICE, did a table shrink as well as did an INDEX REBUILD. Yet, when our application is mapped to DBO.Price i get a response time of 5 records while when it is mapped to DBO1.Price i get a response time of 20 seconds.
The execution plan for both are also the same. I am unable to come to any logical conclusion for the difference in performance. Anything else I am missing that has to be done to have the same response timings.