We have an app that utilizes several VFP tables that are about 200-600 MB in size (a few million records.)
Queries hit these tables every day, so we try to keep the physical order reflective of the queries (i.e. physical order is in acct/item/date order). This makes a BIG impact on queries.
However, we soon will be 'upsizing' to SQL Server. Anyone familiar with what happens then? In other words, are queries against back-end SQL Server databases as sensitive to the physical order as VFP databases appear to be? (I guess the question gets to the root of the indexing structure, and I know nothing about how SQL Server handles it).
TIA,
Kevin