>ya tengo un indice por el campo codigo, hice un nuevo indice "index on !deleted() tag borrados" y la rpta es la misma 1.3 seg en el servidor y 30sg en un terminal, ahhh lo olvidaba la rpta es 1 sólo registro.
Haz el indice otra vez: INDEX ON DELETED() TAG borrados Luego prueba la consulta con SET DELETED ON y con DELETED OFF a ver que diferencia tiene.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
