Tech blog

How To Create And Insert Data In Postgre Hstore

June 6, 2022June 9, 2022Studio-ScalaDatabase, database management system, dbms, hstore, Postgre, postgre datatype, postgre hstore, postgreSQL, rdbms, sql, Tech blog, technology

Reading Time: 2 minutes Postgre without a doubt is one of the most popular databases in the market. The reason behind this is PostgreSQL’s speed, security, and robustness. PostgreSQL isn’t just a relational database. PostgreSQL invented many post-relational concepts like in-database functions and user-defined datatypes. Other than that it has many amazing features like Hstore. Now, this blog is for you if you want to know about PostgreSQL Hstore. Continue Reading

Apache Calcite : A Quick insight on Cost-based Optimization

February 28, 2022February 28, 2022Tech BlogsApache Calcite, java, Java Studio, Tech blog

Reading Time: 3 minutes Hello folks , In this blog , We will discuss about what is Query Optimization,what is a plan cost is , how we can use to drive optimizer decisions and Issues In Cost-Based Optimization. What is Query Optimization: We can execute a single query through different algorithms or re-written in different forms and structures. Hence, the question of query optimization comes into the picture – Continue Reading