Re: when to use associative arrays?

From: Mark Bole <makbo_at_pacbell.net>
Date: Wed, 28 Sep 2005 00:22:15 GMT
Message-ID: <Xml_e.3207$KQ5.2201@newssvr12.news.prodigy.com>

Jens wrote:

> Hi,
>
> the Oracle documentation recommends the use of associative arrays for
> "relatively small lookup tables". Is there a rule of thumb to determine
> the number of entries up to where it makes sense to use an associative
> array ?
>
> Using Orcacle 9.2.0.3.0 on Win2000 Server
>
> Jens
>

As many as you can fit into memory. Exactly how to measure that, I couldn't say, sorry.

-Mark Bole Received on Tue Sep 27 2005 - 19:22:15 CDT

This message: [ Message body ]
Next message: fitzjarrell_at_cox.net: "Re: MYDUL avaialbe for recovery, another choise of DUL."
Previous message: jkstill_at_gmail.com: "Re: Any easy way to chenge the SORT_AREA_SIZE setting of import session?"
In reply to: Jens: "when to use associative arrays?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US