Re: Crosstab performance
From: <aravind.kanda_at_gmail.com>
Date: Tue, 11 Mar 2008 13:40:41 -0700 (PDT)
Message-ID: <ec43a4b0-eeb3-4b24-9b30-96449b9d51c8@i12g2000prf.googlegroups.com>
Date: Tue, 11 Mar 2008 13:40:41 -0700 (PDT)
Message-ID: <ec43a4b0-eeb3-4b24-9b30-96449b9d51c8@i12g2000prf.googlegroups.com>
Thanks for the quick response David. Here is the server specs:
Platform: SUNW,Sun-Fire-480R
OS: SunOS 5.9
No of processors : 4( each 1200 Mhz)
Memory: 16384 MB.
Oracle 9i.
Although I am leaning more on having a table rather than view with a dynamic sql, i would still like to know if dynamic sql is a drag.
thanks. Received on Tue Mar 11 2008 - 15:40:41 CDT