This is the third article of my 12c Adaptive Sampling series. Previously, we saw in Part 1 how ADS works for a single table (also for a group by clause) and in Part 2 for joins. As you know join card...
This is the second article of my 12c Adaptive Sampling series. In part I, we saw how dynamic sampling estimates single table and group by cardinality. In this part we will focus on how Adaptive Dynami...
How to know if I will be able to use successfully my RMAN Backup? that's is a question performed for many DBA's, RMAN also provide functions to validate corrupted blocks in the database, but also it p...
Using indexes can improve the performance of applications using the database. This is a pretty well known fact. However, determining which index, or combination of indexes that will give you the best ...
Toad offers cool feature called make/strip code. It allows you to copy code from, say, C# or Java into Toad, turn it into simple SQL, optimize it, then send it back to the original format for inclusio...
Yes. In Editor, right-click and choose Refactor: convert to/from ANSI join. The query builder also offers this functionality. For example, you can send Editor contents to the query builder to "see" yo...
Q: Is there a way to understand why indexes aren't being used, even if they are referenced in the WHERE? A: Not really. For example, suppose WHERE GENDER = 'M' and I know there is an index in the col...
Q: I assume that the indexing in Exadata is not as important due to cell storage. Generally speaking, “full table scans” are not to be avoided as with non-Exadata databases. Exadata has numerous mecha...
In this article you will learn how Oracle 12c dynamic sampling works. Cases where it helps the optimizer do good estimations as well as cases where it doesn’t will be presented. Only single table sele...
Questions and Answers on Toad for Oracle Database Versions: Q1: Does Toad support Oracle RDB, Times Ten, or Berkeley DB? A1: The answer is NO to all of these. Essentially, these are all radically di...
A: No. The 64-bit version simply allows your program to use more memory. There is no real advantage to 64-bit unless you want to fetch a one-billion-row table all into memory on your PC within a Toad ...
A: Not necessarily. Actually, we recommend that, instead of the DBA role, you grant discrete privileges; that grants everything! Within Toad, we try to use USER_ and/or ALL_ where possible, but a few ...
