Hi
I just read your article. This not a problem for oracle as long as you can
afford to index all these columns.
I have got a table with 8-10 Million records with all these FKs indexed and
it performs reasonbaly fast of course on a 4 CPU HP-UX!
Reza
Sanaa BELBAGRI <belbagri_at_ispalliance.net> wrote in message
news:37FA4893.37E8F0CA_at_ispalliance.net...
> Hi all,
>
> I am implementing a database using ORACLE and I have a problem.
> One of my tables contain 5 foreign keys moreover it's supposed to be one
> of the biggest and most accesible table in the application.
> So I wonder what can I do to avoid the problem of a very bad performance
> in term of access to the table (for example withdraw the foreign keys
> and treat the problem on the programming side by testing everytime the
> data entred,....etc).
> Can you help?
>
> Many Thanks
>
>
>
>
>
Received on Thu Oct 14 1999 - 06:54:56 CDT
