Hi Guillaume, > if restricting in the where clause on VehicleID, then you should create > an index on VehicleID.
I' not sure I understeand correct. Does this mean that if I uses 'where' clauses it is not needed to make indexes and it make index itself when needed ? By now I have made an index on every 'search thing' I use in where clause. Since I dont find instructions to say to the database which index to use, I assume it uses the right ones itself. But when it autocreate indexes... hmm should be nice thing :) Unless of course I misinterprete :( --- Rgds, Wilfried http://www.mestdagh.biz