Re: proc installed on win95, oracle database on hp box

Hi Chip,

    What I am about to utter is rank heresy, but .... for small tables keys, primary or otherwise, can actually reduce performance. In a properly tuned database Oracle will probably be reading 64KB at a time from disk. The amount of time required to read in the index (which tends to be one Oracle block at a time) and then read the data is greater than the time required to read the data and select the desired row from RAM.

    Many lookup and reference tables fall into the less than 64KB category, for example, a lookup table for US state names and postal abbreviations.

    Incidentally, keys are not necessary to uniquely identify records provided that the contents uniquely identify the record.

regards

Jerry Gitomer

chip_cii_at_my-dejanews.com wrote in message <7i1tq1$i97$1_at_nnrp1.deja.com>...
>Hi out there,
>
> I'm a developer at my company and I've been tasked with
>evaluating pro*c for use with our system. Now the database is installed
>on a midrange HP unix box. Unfortunately we do not have the pro*c
>installation package either because it got lost by the previous
>personnel or we didn't have pro*c as an option when we acquired it. What
>we do have is a pro*c win95 nt installation disk.
>Using the pro*c software installed on my pc can I access the oracle
>database in the hp unix box?
>I have worked with pro*c before in my previous company but that version
>was installed in the oracle server in the hp unix box. Please let me
>know what's possible.
>
>Chip
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Fri May 21 1999 - 08:58:33 CDT