Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum Custom SQL non clustered indexes
    • Sign In

    • State Verified Answer
    • +1 person also asked this people also asked this
    • Replies 1 reply
    • Subscribers 59 subscribers
    • Views 1291 views
    • Users 0 members are here
    • custom index
    • ProjectWise
    • SQL
    • Database

    Custom SQL non clustered indexes

    Sandy McLean
    Offline Sandy McLean over 5 years ago

    Is this true? From our database team ...  Our DBAs feel we no longer need to ask Bentley’s approval to create non-clustered indexes. They just need to inform the PW Administrators that they are creating it, after having tested it in the environments. Index will be tested on the Alpha and Beta server to validate issues are addressed with no ill side effects. Per the Bentley prescriptive guidance, these are pre-approved changes. This information is both from conversations with Bentley and based on experience with these indexes.

    • Sign in to reply
    • Cancel

    Top Replies

    • Marty.Nickel
      Offline Marty.Nickel Fri, Sep 15 2017 10:12 AM +1 verified
      Hi Sandy, This is absolutely untrue and will put you in an unsupported environment. Any and all indexes need to be vetted by development before being applied to the product. DBAs that feel they can apply…
    • Marty.Nickel
      +1 Offline Marty.Nickel Fri, Sep 15 2017 10:12 AM

      Hi Sandy,

      This is absolutely untrue and will put you in an unsupported environment. Any and all indexes need to be vetted by development before being applied to the product.  DBAs that feel they can apply indexes to the system without Bentley's approval have caused massive deadlocks, slowness and overall poor performance for PW systems across the globe.  I myself have removed dozens of DBA applied indexes to PW systems that have caused problems, and once they are gone the problems go away.  Without proper load testing there is no saying what an index can or cannot do.  If your DBA has applied indexes to your db and you experience any problems, the first thing we are going to ask is that you remove them.  

      If you have any questions, please let me know.

      Thanks,

      Marty



      Answer Verified By: Vickie Ramsey 

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Verify Answer
      • Reject Answer
      • Cancel

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies