Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    italy
    Posts
    4

    Cool Unanswered: scan/seek/sql 7.0 e sql 2000

    hello,
    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
    thanks
    maurice

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you updated the statistics ?

  3. #3
    Join Date
    Aug 2002
    Location
    italy
    Posts
    4
    Originally posted by rnealejr
    Have you updated the statistics ?
    I have not still tried launch sp_updatestats on db master and msdb. thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •