SQL Server Performance Tuning but this time the question was more related to the MySQL installation they had in their system. Query Using Temp Table.
One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’.
Question: Retrieve TOP 10 Rows Without Using TOP or LIMIT? We do not want to use TOP or LIMIT as they are actually not an ANSI implementation.
Essentially, they wanted to know command which can Show Engines to Display All Available and Supported Engine in MariaDB.
While it was easy to write a stored procedure in SQL Server, for MariaDB and MySQL one has to know a bit of syntax to write the very first stored procedure.