I have a database written with sql 7,0,
se I execute the following instruction in query analizer select max(idcodice) from company, uses index corrected with instruction seek.
I have carried the database in sql2000 and in order to execute the same instruction it uses the scan and it turns out slower.
if compatible tax database sql 7,0 still uses the seek. as I can make in order to use the database in sql2000 but using inquesto example the seek in place of the scan.
I have already tried to reconstruct the indices but it does not change null