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 ...
A: Aside from privileges to connect, of course, some of the Schema Browser features might require access to the Data Dictionary views. Within Toad, we try to use USER_ and/or ALL_ where possible, but ...
Toad for IBM DB2 v6 is nearly ready and due for launch in mid-December. I wanted to give everyone an update of what’s coming now so you’ll be prepared. There's a lot of nice improvements! New/Up...
Role transitions are no more complicated starting from Oracle Database 12c. Role transition, basically, comprises switchover and failover. Using the previous release role transitions, in order to perf...
Introduction You’ve probably been reminded very often that force logging is important in a Data Guard configuration and have also been warned about the dramatic consequences that might happen in a dat...
There are mainly three problems that database SQL optimizer cannot find the best way to process your SQL statements. Cost estimation error The cost estimation error is not only caused outdated stat...
In the real world I found that most customers have two or more different database vendors in house and sometimes there is a business need to join both database environments. I found some features in T...
