Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    UK
    Posts
    1

    Question Unanswered: Issues With Force Indexing when upgrading to Sybase12.0 from 11.0

    Hi,

    We are doing upgradation from Sybase 11.0 to Sybase 12.0.

    Will the using of force indexing in stored procedures is a problem?
    will it cause any performance degradation?

    Thx.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    No more performance degradation then you have in System 11, however after updating your index statistics on ASE12 I would try running the query plan output to see if ASE selects the 'correct' index.
    Thanks,

    Matt

Posting Permissions

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