>>Why do they need to be indexed? For uniqueness support? After all, you can't SEEK() on them...
>
>Is it that we don't have to index anything on SQL Server? ...assuming SQL Server will adjust
>as per the queries which will take place.

No, you need indexes: you just don't necessarily need the same indexes as you do in VFP. SQL Server doesn't automatically tune the indexes, but it does collect statistics on database access, which you can use to decide which indexes you need. The Index Tuning Wizard will help with this decision.