Re: small table takes more time as compared to bigger table

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Tue, 17 May 2011 14:42:41 -0700 (PDT)
Message-ID: <8aba67cc-fe4a-4e18-b70f-bab51192e068_at_d15g2000yqn.googlegroups.com>

MadhavC:

# I run the query as below for 16000 times for different values of col4 in where clause-

Don't do that ... don't run any query 16000 times ... use SQL and join things together so that you run the query once.

Give Oracle as much work as is needed to be done in as few statements as possible ... Received on Tue May 17 2011 - 16:42:41 CDT

This message: [ Message body ]
Next message: onedbguru: "Re: small table takes more time as compared to bigger table"
Previous message: John Hurley: "Re: v$abc.. table names - nightmare"
In reply to: MadhavC: "small table takes more time as compared to bigger table"
Next in thread: onedbguru: "Re: small table takes more time as compared to bigger table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message