General discussion

Locked

Access vs. SQL

By bratchev ·
Is there a limitation in SQL Server on the number of indexes per table as there is in MS Access, for example(Access limits the number of indexes per table to 32)? Do you know of any articles or white papers on the topic of Access vs. SQL Server?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access vs. SQL

by n_k_goyal In reply to Access vs. SQL

It may depends on version to version. I have
not seen any such limitation in SQL server.
May be it depends on number of fields or on
data block size.

Nitin

Collapse -

Access vs. SQL

by bratchev In reply to Access vs. SQL

Poster rated this answer

Collapse -

Access vs. SQL

by donq In reply to Access vs. SQL

I have been using Access 9 years and recall an original (Access 2.0) limit of 16 indexes. I just checked Access 2000 on line Help and it says there is a limit of 32 Indexes in a Table. I couldn't find anything in SQL-Server however I would think the same limit applied. If someone needs 32 indexes their data is most likely not normalized anyhow??? I can't imagine an efficient data model using more then 6 or 7 indexes MAX.!

Collapse -

Access vs. SQL

by bratchev In reply to Access vs. SQL

Poster rated this answer

Collapse -

Access vs. SQL

by bratchev In reply to Access vs. SQL

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums