
104 Accelerating MATLAB
®
Performance
proler helps determine the situation in specic cases. Note that table joins and subqueries
are not inherently slow: they are often slow due to inefcient implementations more than
due to any intrinsic slowness.
236
As a special case, we often do not actually need to retrieve data from a table but only
information about whether or not a certain condition exists in the data. In such cases,
using the EXISTS or IN semi-join operators in a subquery can signicantly improve the
query performance compared to a regular table join.
237
When deleting all data in a table, it is much faster to TRUNCATE it (a DDL action ...