Re: best way to "parameterize" a tablename?

From: <mh_at_pixar.com>
Date: Fri, 22 Aug 2008 00:13:31 GMT
Message-ID: <Lwnrk.25272$Ri.4509@flpi146.ffdc.sbc.com>


gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net> wrote:
> <mh_at_pixar.com> wrote in message
> >
> > if tablename = 'FOO'
> > insert into foo ...
> > else if tablename = 'BAR'
> > insert into bar ... (exact same stuff)
> > etc...
> >
> Use bind
> variables.)

I guess that's what I'm asking... how can I use bind variables or equivalent for the table name?

> You have an odd schema is each table has the same structure but a different
> name.

There's a reason for it, we basically don't want to intermingle one set of data with another. Think of the case where there's a million records of FOO and 100 records of BAR. An index won't be very useful, so you end up doing a lot of full table scans to extract the data, and we don't want to pay the big cost of FOO for the tiny data from BAR. The real case is a bit more complicated, but that's what it boils down to.

Thanks!

-- 
Mark Harrison
Pixar Animation Studios
Received on Thu Aug 21 2008 - 19:13:31 CDT

Original text of this message