EverSQL Database Performance Knowledge Base

We have 5 tables and we are trying to create a view to get the results.

Below is the view which is working fine.

I need suggestions. Is it a good practice to write this query in this way or it can be optimized in a better way.

SELECT p.Pid,  hc.hcid, hc.Accomodation, ghc.ghcid, ghc.ProductFeatures,   wp.existing, wp.acute, mc.cardiaccover, mc.cardiaclimitationperiod
FROM   TableA p 
      LEFT JOIN TableB hc 
             ON p.pid = hc.pid 
      LEFT JOIN TableC ghc 
             ON p.pid = ghc.pid 
      LEFT JOIN (SELECT * 
                 FROM   (SELECT hcid, 
                                title, 
                                wperiodvalue + '-' + CASE WHEN 
                                wperiodvalue > 1 THEN 
                                unit + 
                                        's' ELSE 
                                unit END wperiod 
                         FROM   TableD) d 
                        PIVOT ( Max(wperiod) 
                              FOR title IN (acute, 
                                            existing 
                                           ) ) piv1) wp 
             ON hc.hcid = wp.hcid 
      LEFT JOIN (SELECT * 
                 FROM   (SELECT hcid, 
                                title + col new_col, 
                                value 
                         FROM   TableE 
                                CROSS apply ( VALUES (cover, 
                                            'Cover'), 
                                                     (Cast(limitationperiod AS 
                                                           VARCHAR 
                                                           (10)), 
                                            'LimitationPeriod') ) x (value, col 
                                            )) d 
                        PIVOT ( Max(value) 
                              FOR new_col IN (cardiaccover, 
                                              cardiaclimitationperiod, 
                                              cataracteyelenscover, 
                                              cataracteyelenslimitationperiod
                                             ) ) piv2) mc 
             ON hc.hcid = mc.hcid 

Any suggestions would be appreciated.

Thanks

• Multiple-by-record-value
• Scalar-function-(NON-table-valued-function)-in-PostgreSQL
• How-to-optimize-mysql-query-using-php/mysql-eager-loading-or-similar-approach
• What-is-the-best-way-to-pick-a-random-row-from-a-table-in-MySQL?
• Massive-SQL-query-requires-conversion-to-LINQ
• how-to-reduce-time-for-running-query-in-postgres
• Performance-issue-in-SQL
• Date-difference-get-different-results-from-function-than-from-select-statement
• Why-adding-a-new-column-to-an-existing-table-destroyed-the-performance-of-a-query?
• Referencing-another-table-with-the-same-key-value
• First-day-of-the-month-retrieval-from-SQL-table-with-existing-dates
• SQL-Server-2014---SQL-Case-statement-on-columns
• How-to-copy-meta_value-of-wp_usermeta-to-the-same-table-however-different-meta_key?
• Multiple-updates-query
• MySQL-loads-CPU-100%-for-a-minute-with-SELECT-into-SELECT
• Searching-for-a-specific-text-value-in-a-column-in-SQLite3
• in-select-query-when-use-column-name-it-is-very-slow
• Slow-Execution-of-MySQL-Select-Query
• MySQL-Select-from-UNION-performance-issue-(kills-database)
• How-to-rewrite-a-SQL-query-that-contains-repeated-SubQuery?
• SIMPLE-SQL-Select-Where-Query
• Try-to-define-a-left-join-only-with-where-condition
• MySQL---bad-performance-with-simple-order-by
• Sort-by-id-desc-on-multiple-columns-distinct-postrges
• how-to-make-SQL-performance-improvements?