Re: binding multiple values and retain blanks

From: Jared Still (jkstill_at_cybcon.com)
Date: 10/24/04 

To: Ravi.Kongara@Sun.COM
Date: Sat, 23 Oct 2004 15:15:24 -0700

On Fri, 2004-10-22 at 14:47, Ravi Kongara wrote:
> I got to try this in terms of performance. I'm running this program for
> more than 100 different tables parallelly. So i have to create so many
> temp tables at a time and populate them with the given data and then
> run the query by joining with temp tables. I think this increases the
> overhead

The key phrase is "I think this increases the overhead..."

Test it to be sure.

Don't let the DBA catch your parsing those ridiculously long SQL
statements.

Jared

Relevant Pages

  • Re: How to Create Local Temporary Table
    ... As Daniel pointed out, many times, it is locking that forces one to look at temp tables and Oracle does not share this problem. ... With the improvements in Oracle 9i and 10g and what Oracle has added to its SQL feature set, one can most often get by with just a single SQL statement, which is more efficient than writing data to a table and then reading it back again. ... If it places the group's minds at ease DB2 supports neither VARRAY nor local temps. ...
    (comp.databases.oracle.server)
  • Re: Indented Bill of Materials
    ... but eventually I will be calling SQL ... > have no parent are inserted in a temp table, ... > execution of the WHILE statement, the last executed statement is the SET ... > In the first iteration, @lev will be increased to 1. ...
    (microsoft.public.sqlserver.programming)
  • Re: help: Timeout expired. The timeout period elapsed prior to completion of the operation or the se
    ... Actually we are putting records in a temp table which qualify according ... code fails very much even before transaction starts. ... unless really needed pls dont use lock hints as SQL ...
    (microsoft.public.sqlserver.server)
  • Re: Order by in a INSERT INTO..SELECT
    ... Insert Into #TempPaging ... I can't provide a reproduceable scenario right now without making this ... select from the temp table will not fix the problem. ... seen this on SQL 2000 servers. ...
    (comp.databases.ms-sqlserver)
  • Importing text file
    ... The a temp table is created and the textfile is imported ... I read some stuff about DTS packages but I'm not real familiar with SQL ... Server and don't know how exactly to call the DTS package from my ...
    (microsoft.public.vsnet.general)