RE: Any suggestion for sql query optimization in sql
OK, here goes: 1) Remove the INDEX HINT. Let SQL Server optimize on its own; it will usually pick the right path if the SQL is well-written. 2) Use modern SQL syntax. Much easier to pick out JOIN mistakes... 3) What on Earth is the normalized structure of your data? I know the insurance indusry […]
2003-06-05