DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Index

  1. 06-05-2003, 08:15 AM #1
    netbar
    netbar is offline Member
    Join Date
    Jul 2001
    Posts
    181

    Index

    I have a query which when run on one database makes use of the index, when run on the other does not and takes 45 minutes longer.

    I have used a hint and changed the optimzer to rule and forced the index to be used on the second db, and when that is done the query returns much faster.

    I have analyzed the table in question with compute statistics but the CBO still does not pick up the index.


    ANy ideas?




    Cheers
    Reply With Quote Reply With Quote
  2. 06-05-2003, 10:09 AM #2
    netbar
    netbar is offline Member
    Join Date
    Jul 2001
    Posts
    181
    Problem resolved!


    Cheers!!
    Reply With Quote Reply With Quote
  3. 06-05-2003, 10:28 AM #3
    patel_dil
    patel_dil is offline Senior Member
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Btw, what was it?
    -- Dilip
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width