Tag Archives: SQL

What is SQL Query optimization | Performance tuning in SQL

By | September 19, 2024
0 Comment
SQL Query optimization and performance tuning

In J2EE enterprise applications, the performance of the database queries significantly impacts the application’s efficiency. Slow or poorly performed queries delay the response to the end user, decrease productivity, and eventually lead to business loss. There are various techniques that are used for SQL query optimization. In this article, we will learn about SQL optimization… Read More: What is SQL Query optimization | Performance tuning in SQL »

How to configure multiple database in Spring Boot

By | June 18, 2025
0 Comment
add multiple database in Spring Boot

In Enterprise applications, we may be required to have multiple databases for storing different kinds of information. For example, in an e-commerce application, it may be required to keep the user’s information in a different database, product-related information in a different database, and payment-related information in a separate database. In this tutorial, we will configure… Read More: How to configure multiple database in Spring Boot »

MySQL Workbench – How to make database schema in MySQL Workbench?

By | June 17, 2025
0 Comment

MySQL Workbench is an integrated development environment tool for designing and modeling database architecture. It is a unified visual tool for database architects, developers and DBAs(Database Administrators). MySQL Workbench comes along with various integrated tools which can be easily used for administrating purposes of server configurations, executing SQL queries, complex database schema designing and management,… Read More: MySQL Workbench – How to make database schema in MySQL… »