Chapter 4 - Model 23 About Model 23 Create Model 25 Chapter 5 - Physical Model 27 About Physical Model 27 Add Databases / Schemas to Physical Model 27 Add Tables to Physical Model 28 Add to Physical Model 30 Work with View Builder (Available only in Non-Essentials Version) 31 Edit View's Definition 37 Add Foreign Keys to Physical Model 40 Chapter 6 - Logical Model 41 About About Logical Model 41 Add Entities to Logical Model 41 Add Relations to Logical Model 43 Chapter 7 - Conceptual Model 45 About Conceptual Model 45 Add Entities to Conceptual Model 45 Add

Chapter 4 - Model 23 About Model 23 Create Model 25 Chapter 5 - Physical Model 27 About Physical Models 27 Add Databases / Schemas to Physical Model 27 Add Tables to Physical Model 28 Add to Physical Model 30 Work with View Builder (Available only in Non-Essentials Version) 31 Edit View's Definition 37 Add Foreign Keys to Physical Model 40 Chapter 6 - Logical Model 41 About Logical Model 41 Add a Relation to a Logical Model 43 Chapter 7 - Conceptual Model 45 About Conceptual Models 45 Add Entities to Conceptual Model 45 Add Relations to Conceptual Model 46

(Available only in Non-Essentials Edition) 133 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition) 135 About Model 135 Model Window 136 Physical Models 138 Create Physical Forward Engineering 148 Synchronize to Database 148 Export SQL 152 Model Conversion 154 Print & Export Model 154 Model Hints and Tips 154 Chapter 9 - Debugger (Available only in Non-Essentials On-Prem Server. 2. Open your project, connection, database and/or schema. 3. Click the Query, Model or Charts icon. 4. Right-click anywhere in the Objects tab and select Open Containing Folder.

(Available only in Non-Essentials Edition) 131 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition) 134 About Model 134 Model Window 135 Physical Models 137 Create Physical Forward Engineering 147 Synchronize to Database 147 Export SQL 151 Model Conversion 153 Print & Export Model 153 Model Hints and Tips 153 Chapter 9 - Debugger (Available only in Non-Essentials On-Prem Server. 2. Open your project, connection, database and/or schema. 3. Click the Query, Model or Charts icon. 4. Right-click anywhere in the Objects tab and select Open Containing Folder.

(Available only in Non-Essentials Edition) 129 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition) 132 About Model 132 Model Window 133 Physical Models 135 Create Physical Forward Engineering 144 Synchronize to Database 144 Export SQL 149 Model Conversion 150 Print & Export Model 151 Model Hints and Tips 151 Chapter 9 - Debugger (Available only in Non-Essentials On-Prem Server. 2. Open your project, connection, database and/or schema. 3. Click the Query, Model or Charts icon. 4. Control-click anywhere in the Objects tab and select Show In Finder. Projects

· · · · · · · · · · · · · · · · · · · · · · · · · · · · 3375 14.3.15 TiFlash Pipeline Execution Model· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 3376 14.4 TiDB Distributed eXecution storage architecture, enabling easy scaling of computing or storage capacity separately. The computing layer supports a maximum of 512 nodes, each node sup- ports a maximum of 1,000 concurrencies, and the maximum 2)) to a �→ = 1 AND b = 2 #56005 @ghazalfamilyusa • Increase the cost of table scans in the cost model for scenarios with a high risk of suboptimal execution plans, making the optimizer prefer indexes

· · · · · · · · · · · · · · · · · · · · · · · · · · · · 3359 14.3.15 TiFlash Pipeline Execution Model· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 3360 14.4 TiDB Distributed eXecution storage architecture, enabling easy scaling of computing or storage capacity separately. The computing layer supports a maximum of 512 nodes, each node sup- ports a maximum of 1,000 concurrencies, and the maximum 2)) to a �→ = 1 AND b = 2 #56005 @ghazalfamilyusa • Increase the cost of table scans in the cost model for scenarios with a high risk of suboptimal execution plans, making the optimizer prefer indexes

· · · · · · · · · · · · · · · · · · · · · · · · · · · · 3157 14.3.14 TiFlash Pipeline Execution Model· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 3159 14.4 TiDB Distributed eXecution storage architecture, enabling easy scaling of computing or storage capacity separately. The computing layer supports a maximum of 512 nodes, each node sup- ports a maximum of 1,000 concurrencies, and the maximum Y Y Y Y Y N MPP execution engine - compression exchange Y Y Y N N N N N N N N TiFlash Pipeline Model Y Y N N N N N N N N N TiFlash replica selection strategy Y Y N N N N N N N N N Index Merge Y Y Y

· · · · · · · · · · · · · · · · · · · · · · · · · · · · 3117 14.3.14 TiFlash Pipeline Execution Model· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 3119 14.4 TiDB Distributed eXecution storage architecture, enabling easy scaling of computing or storage capacity separately. The computing layer supports a maximum of 512 nodes, each node sup- ports a maximum of 1,000 concurrencies, and the maximum for statistics is deprecated in v7.5.0. 56 2.2.5 Improvements • TiDB • Optimize the concurrency model of merging GlobalStats: introduce tidb_enable_async_merge_global_stats �→ to enable simultaneous

· · · · · · · · · · · · · · · · · · · · · · · · · · · · 3329 14.3.15 TiFlash Pipeline Execution Model· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 3330 14.4 TiDB Distributed eXecution storage architecture, enabling easy scaling of computing or storage capacity separately. The computing layer supports a maximum of 512 nodes, each node sup- ports a maximum of 1,000 concurrencies, and the maximum This feature simplifies TiProxy deployment and �→ reduces the complexity of the database access layer. 2.2.1 Feature details 2.2.1.1 Performance • The optimizer allows pushing the Projection operator