Runtime Performance on tables loaded direct vs. conventional [message #50898] |
Fri, 12 April 2002 12:48 |
sparkhat
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
We're ran two db builds that create tablespaces, indices, constraints, etc., and load the tables. One build loads the tables directly, one loads conventionally. Running queries against the built databases produces very different results. In the case of the directly loaded DB, we did forget to enable some of the FK constraints that were created, but for a read, why would that make any difference?
Any help greatly appreciated!
|
|
|
|
|