Although changing the name of the view using the sp_rename command is allowed, it is advised to first delete the current view before creating a
Category: MySQL
VIEWS vs Materialized Views in SQL
Here are listed the key distinctions between Views and Materialized Views. This material has been gathered throughout time from a variety of sources and books.
MATERIALIZED VIEWS in SQ Server
Views with computed and stored contents are known as materialized views. To put it another way, materialized views are stored on disk and updated on
MySQL RDS – Publish logs in Cloudwatch
You can access the logs that are produced by each RDS database engine for auditing and troubleshooting. Your database engine determines the kind of logs
Usage of ROW Keyword in MySQL
Subqueries that are scalar or column return a single value or a column of values. A subquery variant known as a row subquery returns a
MySQL RDS – The specified log group does not exist
If you experience the error: There was an error filtering log events The specified log group does not exist, checking the parameter group may be
Big Data & SQL 