Re: Open table with primary key

From: <Ed.Stevens_at_nmm.nissan-usa.com>
Date: Mon, 11 Jan 1999 14:19:44 GMT
Message-ID: <77d19u$jbs$1@nnrp1.dejanews.com>

In article <t0Sl2.1457$kt3.23787_at_typhoon-sf.pbi.net>, "D Huynh" <remove.duchuynh_at_pacbell.net> wrote:
> When opening up an Oracle table with a primary key (using ADO, in
> particular) does Oracle automatically use the associated primary key or do
> we have to do so explicitly?
>
> TIA.
>
>

I'm not sure what you mean by "opening a table" since the concept really doesn't exist in RDBMSs. As for use of the key, one of the fundamentals of any RDBMS is that you cannot force the use of any key or index. You simply SELECT the data you want and the DBMS figures out the most efficient means of retrieving it.

Ed Stevens
Nissan Motor Mfg. Corp., USA

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 11 1999 - 08:19:44 CST