Re: Open table with primary key

While it is certainly possible to INFLUENCE the use of an index by careful structuring of the SQL statement, and it MAY be possible to FORCE the use in some implementations, these would be advanced tuning subjects. The original question appeared to be from someone who had little or no SQL experience and was trying to relate accessing a table to other file access methods. In that context my original answer stands.

In article <369A4ED1.44233265_at_hotmail.com>,   Dharambir Marwaha <dharambirmarwaha_at_hotmail.com> wrote:
> 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
>
>

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 Tue Jan 12 1999 - 07:50:16 CST