Answer Posted / Abhishek Pawar
The Query Cache in MySQL stores recently executed SQL statements along with their results. This caching mechanism can improve the overall performance of the database system by reusing pre-computed results instead of executing the same queries multiple times. However, it should be noted that the query cache is turned off by default in many MySQL configurations.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
define sql insert statement ? : Sql dba
what are aggregate and scalar functions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
If a cursor is open, how can we find in a pl/sql block?
Is primary key always clustered index?
What is the current version of sql?
Can we rollback truncate?
what is collation? : Sql dba
how to start mysql server? : Sql dba
what are all the common sql function? : Sql dba
Is inner join faster than left join?
What is the current version of postgresql?
Can delete statement be rollbacked?
What is the best sql course?
Do we need to rebuild index after truncate?
