simple question: is there a server parameter on SQL SERVER2008 database engine to set a kind of automatic analysis of the queries and set a kind of automatic index?
recently I have seen 2 identical databases, one with MSDE and one with SQLSERVER2008R2. With MSDE there was no index and the queries were fast. An expert told the people in my company that creating an index wasn't necessary because MSDE would
create one automatically if needed (it was few years ago).
For the queries to be as fast as with MSDE, I had created an index with SQLSERVER2008R2. So it wasn't automatically created.
I was wondering if I had missed a parameter that set this kind of automatic index?
Thanks you in advance,
View Complete Post