Buenas otra vez.
En una consulta, he cambiado unas cosillas y las estadísticas han cambiado,
como era de suponer.
Ahora, la tabla viabil , en vez de 2420 logical reads, realiza 1213. Creo
que sigue siendo mucho (¿verdad?), pero algo es algo. Pero ahora aparece
otra tabla más (ic_numaco).
Mi pregunta es: ¿vale la pena reducir a la mitad pero añadiendo otra tabla?
Espero haberme explicado bien.
Table 'ic_billetes'. Scan count 3, logical reads 12, physical reads 0,
read-ahead reads 1.
Table 'ic_tarpax'. Scan count 3, logical reads 6, physical reads 0,
read-ahead reads 0.
Table 'ic_bilper'. Scan count 4, logical reads 20, physical reads 1,
read-ahead reads 0.
Table 'ic_desperbil'. Scan count 1, logical reads 263, physical reads 0,
read-ahead reads 0.
Table 'ic_tipdes'. Scan count 1, logical reads 2, physical reads 0,
read-ahead reads 0.
Table 'ic_viabil'. Scan count 2, logical reads 2420, physical reads 0,
read-ahead reads 0.
Table 'ic_billetes'. Scan count 3, logical reads 12, physical reads 0,
read-ahead reads 0.
Table 'ic_tarpax'. Scan count 3, logical reads 6, physical reads 0,
read-ahead reads 0.
Table 'ic_bilper'. Scan count 3, logical reads 15, physical reads 0,
read-ahead reads 0.
Table 'ic_desperbil'. Scan count 1, logical reads 263, physical reads 0,
read-ahead reads 0.
Table 'ic_tipdes'. Scan count 1, logical reads 2, physical reads 0,
read-ahead reads 0.
Table 'ic_numaco'. Scan count 1, logical reads 3, physical reads 0,
read-ahead reads 0.
Table 'ic_viabil'. Scan count 2, logical reads 1213, physical reads 0,
read-ahead reads 0.
Leer las respuestas