Re: Global Temporary Table Scalability Problem

"william milbratz" <milbratz_at_hotmail.com> wrote in message news:cee3515e.0402060834.7df3e1e_at_posting.google.com...
| Hi,
|

...

| Some more info:
| the procedure in question receives as one of its params a
| comma-delimited-list of "principal Ids". This list is usually very
| short (1-6 entries). The procedure parses the list and populates a
| 1field/1key temp table. The procedure then uses that table in a
| complicated query to return the records "which the user has access
| to".
|

....

would you be able to use SELECT FROM TABLE(CAST...) syntax or a pipelined function instead of the temp table (depending on version)?

• although the GTT performance is bothersome

can you post explain plans for both the GTT version and the permanent table version?

• mcs