5 Replies Latest reply on Aug 31, 2010 9:10 AM by maxandersen

    [hibernate-tools] Display indices

    dhartford

      Hey all,

      There are times when you are looking at your JPA-QL/HQL queries and want to do some query optimization (change the where clause, order by clause to more effectively use existing compound keys for example).

       

      Would it be possible to, in the Hibernate Configuration view under the Database tree node, to also show indices (compound keys in particular) for people interested in this level -- other any other ideas on how to help with quick/easy query optimizations of your JPA-QL/HQL queries.

        • 1. Re: [hibernate-tools] Display indices
          maxandersen

          For that you should look into DTP which is a much more complete Database browser.

          1 of 1 people found this helpful
          • 2. Re: [hibernate-tools] Display indices
            dhartford

            If you already have the Hibernate Configuration view open to see all the Class objects available, and the HQL editor open (the HQL/JPA-QL query you want to optimize), and have the Dynamic SQL Preview view open to see the actual query, I was kind of hoping to just add to the Hibernate Configuration view (that you may already have open) that index information in its Database tree node.

             

            Just seems like keep adding in more views/swapping to more tools (such as a DTP view), when there is an opportunity for improvement.

            • 3. Re: [hibernate-tools] Display indices
              maxandersen

              Yes, but we don't read *all* metadata I think you want to get at - DTP does.

               

              For now, using the DTP View will give your more info.

               

              In case of you using DTP connections we could probably put in a "DTP Database" node instead of/or next our "Database" node which

              is just whatever the Hibernate Configuration model contains about the database and not what is necessarily directly in there.

              • 4. Re: [hibernate-tools] Display indices
                dhartford

                Having a DTP Database node option/instead of current database node in hibernate tools actually would be great, with the one expectation of it being a more convenient starting point in the DTP tree (instead the deep-tree digging one must normally do with DTP server->database->schema-><actual stuff I care about> (maybe to schema then stuff, as some people work with multiple schemas).

                • 5. Re: [hibernate-tools] Display indices
                  maxandersen

                  jira feauture request is your friend

                  patches implementing it your best friend

                   

                  /max