Francisco H Tapia
my.lists at verizon.net
Mon Apr 14 18:32:07 CDT 2003
Susan, in good humor, :), You remember that book you co-authored right, SQL: >From Access to Sql Server?, Access Data Projects are nothing more than Code, and Gui that hook into Sql Server, all the tables, views, sprocs (stored procedures) are held in a Sql Server Engine (be it Sql 7/2000/MSDE 1/2). And you can tell Rabit that caffenie is a good replacement for Vitamin A ;o) (just brute force!!! :D) just remember this, just because a little is good, does not mean that a WHOLE LOT is going to be better, if you find yourself needing 249 indexes in a table, perhaps it's time to look at normalizing your whole DB :) -Francisco http://rcm.netfirms.com On Monday, April 14, 2003 4:22 PM [GMT-8], Susan Harkins <harkins at iglou.com> wrote: : Wow... thanks Franciso -- 249? I'm wondering if this holds for an : Access project -- I mean the tables are SQL Server, right? Rabbit : wants to know if rootbeer has vitamin A? :) : : Susan H. : : :: Each table can have as many as 249 nonclustered indexes (regardless :: of how they are created: implicitly with PRIMARY KEY and UNIQUE :: constraints, or explicitly with CREATE INDEX). Each index can :: provide access to the data in a different sort order. : : :