How do I fix 2 identical schemas where 1 query executes quickly and the other takes a minute and a half
Posted on 2011-02-17
I have 2 identical schemas (i.e. same indexes, tables, records, etc). when I execute the following query in schema 1 it is instantaneous. However when I execute it in schema 2 it takes about a minute. how do I resolve this issue so that execution of the query is instantaneous in schema 2?
Here is the query:
STI_RECORD.db_updated DESC )
rownum <= 25;