Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: all foreign key should have index?

Re: all foreign key should have index?

From: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Thu, 2 Feb 2006 20:27:41 +0000
Message-ID: <MWjymgD9sm4DFwXT@deptj.demon.co.uk>


In message <HdqEf.30$cJ2.7533_at_news.uswest.net>, Dan <dan_at_nospam.com> writes
>
>Please don't say "embed a pointer in the record..."

Why not, as part of the low-level implementation? As long as the API is purely relational and there is no way of subverting it, the low level is whatever you can invent that works fast.

The physical layer does _not_ have to look like a table!

-- 
Eric Junkermann
Received on Thu Feb 02 2006 - 14:27:41 CST

Original text of this message

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