[dba-SQLServer]Re: [AccessD] indexes in ADP

Francisco H Tapia my.lists at verizon.net
Fri Apr 4 09:54:33 CST 2003


ADP's are nothing more than FE hooks to a Sql Server.  Indexes are a
database function and therefor available through the sql server engine.  To
use Non/Clustered indexes you will have to specify them when in the table
design view.  If a table has a clustered index, and you access the db via an
ADP that ADP makes calls to a sproc/view and IT (the sproc/view) uses these
in the optimizer to access your data.  Adp's do nothing more than connect
and request the data.

-Francisco
http://rcm.netfirms.com

On Thursday, April 03, 2003 5:07 PM [GMT-8],
Susan Harkins <harkins at iglou.com> wrote:

: What kind of indexes does an ADP use -- clustered or non-clustered?
: I'm guessing clustered.
:
: Susan H.
:


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the AccessD mailing list