Useful tips for everyday
How do I remove duplicate indexes? drop_duplicates() function return Index with duplicate values removed. The function provides the flexibility to choose which duplicate value to…
How to create a JSONB column in PostgreSQL? Basics of PostgreSQL’s JSONB data type 1 Creating a JSONB column 2 Inserting a JSON document 3…
How to map a login to a database user? Using sp_change_users_login or ALTER USER to map a login to a database user can save you…
Which is the default value for InnoDB flush log at TRX commit? The default value is 1, which helps keep InnoDB ACID Compliant. If the…
How do I restrict access to SQL database? Answers Create a user account (make sure its not mapped to any Database) Right Click on the…
What is an index database design? An index, as you would expect, is a data structure that the database uses to find records within a…
How to speed up group by queries in MySQL? Join each row of table a with b, c and d – this means that each…
What is the use of Nologging in Oracle? LOGGING/NOLOGGING helps manage enabling direct path writes in order to reduce the generation of REDO and UNDO.…
How to select with distinct on all columns? Example : SELECT with DISTINCT on all columns of the first query. To get the identical rows…
How do you find a correlated subquery? A Correlated subquery is a subquery that is evaluated once for each row processed by the outer query…