Re: Data Warehouse - Upload Time

From: <karsten_schmidt8891_at_my-deja.com>
Date: Tue, 14 Sep 1999 07:04:29 GMT
Message-ID: <7rks1p$154$1@nnrp1.deja.com>

In article <7rj40i$nve$1_at_nnrp1.deja.com>, Nandakumar <N.Kumar_at_rocketmail.com> wrote:

> to 1 or 2 million records. Can anyone who has
used Dynamic SQL in Data
> Warehouse, suggest if this is a right idea to
continue with DYN SQL, or
> they should be changed to static SQLs.

Hi,
I don't have a lot data-warehouse experience, but in general, the difference dynamic vs. static sql is academic, _if_ your app is using dynamic sql in a sensible way.
(e.g. using bind variables, parse once, execute multiple times)

Cheers Karsten

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 02:04:29 CDT