🚀 go-pugleaf

If you need to do the search once, use SQL, if you need to do multiple
searches in one table, use Seek. BTW, indeces are supported for MS Jet but
usually OLEDB providers do not support indeces. For example, OLEDB provider
for MS SQL Server does not support them.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Alain M. Dube" <adube@cadencesoftware.com> �������/�������� � ��������
���������: news:400fda69$1@newsgroups.borland.com...
> Hi Vassiliev;
>
> Thanks for the info.  Do you have any idea what the performance
> characteristics are for searching an Access database using TADOTable->Seek
> vs. TADOQuery with SQL statements?
>
> Thanks again.
>
> Regards;
>
> Al Dube
>
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:400fcfe1$2@newsgroups.borland.com...
> > TADOQuery can not use indeces. Use TADOTable with CursorLocation =
> > clUseServer and TableDirect = true.
> >
> > //------------------------------------------
> > Regards,
> > Vassiliev V. V.
> > http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
> > http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> > MS Jet (Access) and Interbase (through OLEDB)
> >
> > "Alain M. Dube" <adube@cadencesoftware.com> �������/�������� � ��������
> > ���������: news:400eb1ef$1@newsgroups.borland.com...
> > > Hello;
> > >
> > > How do queries via SQL statements in a TADOQuery object make use of a
> > target
> > > MS Access Database's indices?  Do the fields named in a SELECT
statement
> > > drive the use of anparticular index?  Is there a direct way to specify
> > which
> > > index to use in a query?
> > >
> > > Thanks in advance for the help.
> > >
> > > Regards;
> > >
> > > Al Dube
> > >
> > >
> >
> >
>
>