[AccessD] indexes in ADP

Mwp.Reid at Queens-Belfast.AC.UK Mwp.Reid at Queens-Belfast.AC.UK
Fri Apr 4 10:16:33 CST 2003


As said the Idex is a function of the DBMS not the ADP. Just set them in the 
Table design or via EM.

One clustered per table any number of non clustered.

Martin

Quoting Francisco H Tapia <my.lists at verizon.net>:

> 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.
> :
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


More information about the AccessD mailing list