Re: Open table with primary key

This is for ED.
I think you can force use of indexes in your select statement if reqd.One can use HINTS option to do so.Correct me if I'm wrong.

Regards
Dharambir

Ed.Stevens_at_nmm.nissan-usa.com wrote:

> 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 - 13:19:45 CST