SQL language has a history of more than 40 years. Since it was applied, it has been almost everywhere. Every payment record we consume, every user information we collect and every message we send will be stored in the database or its related products, and the language to manipulate the database is SQL! SQL is almost a necessary ...
Posted on Sat, 20 Nov 2021 06:42:25 -0500 by phpBever
The resource usage statistics of each sql statement in the database is often the most troublesome part and the most effective way to locate the problem. In addition, the resource usage can help the DBA to confirm whether the business concurrency increases, whether the hardware resources meet the existing requirements, and whether the parameters ...
Posted on Wed, 10 Nov 2021 20:32:21 -0500 by evanesq
What connection query?
In the actual development, in most cases, the data is not queried from a single table. Generally, multiple tables are queried jointly to get the final result.
In actual development, a business usually corresponds to multiple tables. For example, students and classes have to save at least two tables. Of cour ...
Posted on Mon, 08 Nov 2021 00:39:19 -0500 by jengle52
Theory and test of oracle materialized view
1. Materialized view
(1) Basic concepts of oracle materialized view
Materialized views first need to create materialized view logs, oracle Create a materialized view log table based on the materialized view log created by the user. The name of the materialized view log table is mlog$_Followed by t ...
Posted on Thu, 21 Oct 2021 00:28:17 -0400 by theflea912
❤️ Hello, I'm Gauss squirrel club. Welcome to study~ ❤️
Described in the previous article "9.3 role management" In this chapter, we introduce the wonderful contents related to "9.4 object permission management" in Chapter 9 security management source code analysis.
9.4 object permission management
Permission manag ...
Posted on Sun, 17 Oct 2021 22:16:47 -0400 by Warz