Non-Usage of Indexes @ Production DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Non-Usage of Indexes @ Production DB

  1. #1
    Join Date
    Feb 2004
    Location
    Mumbai, Maharastra
    Posts
    67

    Non-Usage of Indexes @ Production DB

    Hi,

    I have a scenario where in indexes at production db is not getting used up where as in the same scenario at the development db it is getting used up.

    I have a query which @ production db is not using the indexes and performing FULL scans. The same query when executed @ development db is working fine as it is using the indexes that is created on the referenced objects.

    I have crossed check on the list of indexes at production db and development db, both are same and valid.

    Will ANALYSING the indexes at production db will help me out.

    If anyone have better point to state, please do so.
    Regards,
    Surajit K Mitra

  2. #2
    Join Date
    Feb 2004
    Location
    Mumbai, Maharastra
    Posts
    67
    Anyone can put some thoughts to the subject
    Regards,
    Surajit K Mitra

  3. #3
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    If there are different stats, data volumes and distributions in the the two systems, the optimizer might come up with different execution plans.

    Everything needs to be analyzed to enable the optimizer to make the right decisions.

Posting Permissions

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



Click Here to Expand Forum to Full Width