Parsing and many joins

Hi

On Oracle 8.0.6.

We have table containing the following columns: object_id, attribute_id and value columns.

We need to get the full set of attribute names and values for an object as one row, this obviously means alot of joins. When the number of attributes is small the query runs reasonably, but when we move from 16 to 32 attibutes the querytime goes skyhigh(more than quadrupled). Why? Getting 2 rows from the table shouldn't be worse than getting one and then one more?

In general, what parses faster, hinted cost or rule? What can we do to reduce parsetime, pinning in or expanding shared pool is not an option.

ole c Received on Sun Nov 14 1999 - 17:23:15 CST