When you select and retrieve data, the default Query Governor options limit you in the following ways:
You can do this |
You cannot do this |
|---|---|
Join an unlimited number of tables |
Specify cross products |
Retrieve an unlimited number of rows |
Specify outer joins |
Retrieve for an unlimited time |
Use SELECT DISTINCT statements |
You can change the Query Governor default options at any time by selecting or deselecting the options in the Query Governor dialog box. If you are in the Select painter when you change a data selection option, the change is not enabled until you leave the Select painter and open it again.
To use the Query Governor:
Access the Query Governor dialog box as described above and select options:
