SQL
-
Difference between Nosql and SQLDB/Nosql 2019. 8. 25. 11:50
1. Overview When it comes to choosing a database the biggest decisions are picking a relational (SQL) or non-relational (NoSql) data structure. While both the databases are viable options still there are certain key differences between the two that users must keep in mind when making a decision 2. NoSQL 2.1 What is NoSQL NoSQL databases are purpose-built for specific data models and have flexibl..
-
Explain Query Plan and Query Performance with PostgresDB/RDB 2019. 8. 23. 09:34
1. Overview Let's analyze the query plan with Postgres to enhance performance using explain and analysis. 2. Description 2.1 Optimizer The brain of the database, which interprets queries and determines the fastest method of execution. A single query optimization technique can increase database performance drastically. 2.2 Explain & Analyze 2.2.1 Explain Displaying the execution plan that the Pos..