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...
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 ...
