The table A3Test7D4_E is deleted and re-written every time.
The table ENTRY_ATTRIBUTES is large table (millions of records) and it will need
an analyze when made first time. Doesn't look cache is the reason for
this behaviour
here.
RBS
On Wed, Jul 13, 2011 at 1:44 PM, Stephen C wrote:
> What hap
What happens when you let the query run the first time, delete the
records, then re-run the query?
If the same length of time is spent (50 seconds) then I'm at a loss.
If the shorter length of time happens, I'd say blame caching.
On 07/13/2011 06:00 AM, Bart Smissaert wrote:
> Have the following
Have the following query:
INSERT INTO A3Test7D4_J (PATIENT_ID, ENTRY_ID, READ_CODE, TERM_TEXT,
ADDED_DATE, START_DATE, NUMERIC_VALUE, TYPE_SPECIFIC_INFO) SELECT
E.PATIENT_ID, E.ENTRY_ID, E.READ_CODE, E.TERM_TEXT, E.ADDED_DATE,
E.START_DATE, EA.NUMERIC_VALUE, EA.TYPE_SPECIFIC_INFO FROM A3Test7D4_E
3 matches
Mail list logo
