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