Useful tips for everyday
What is a sargable predicate? In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can…
Can we use integer in varchar? VARCHAR (length) A VARCHAR declaration must include a positive integer in parentheses to define the maximum allowable character string…
How can I speed up my Impdp? Maximizing Oracle Import (impdp) Performance Analyze once after the load – Set analyze=n and analyze with dbms_stats after…
What is the difference between not in VS not exists? The most important thing to note about NOT EXISTS and NOT IN is that, unlike…
What is swap utilization Oracle? Issue High SWAP. Swap/paging is used when there is no sufficient free space available on physical memory. Excessive SGA and…
How do you create a common user in CDB? How to do it… Connect to the root container as a common user who has create…
What is a temporary table in PostgreSQL? A temporary table, as its named implied, is a short-lived table that exists for the duration of a…
When does transaction count after execute indicate a mismatching? Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT. When any error occur…
What is PostgreSQL server process? A postgres server process is a parent of all processes related to a database cluster management. Each backend process handles…
Does server restart clear cache? Yes it does. Since SQL Server is in charge of maintaining those caches, when you shut down SQL server’s services,…