Is the Explain SQL function database-specific ?
yes it is. It must be database specific because it shows what the database is doing.
But also MSSQL shows you the index information.
Check the Explain, and search for clustered index seek, behind you will something like
tablename1, telling you that the first index was used. Primary index is tablename0.
Siegfried
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.