Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Optimize |
Fri, Jun 30 2006 9:28 AM | Permanent Link |
Sanford Aranoff | How can one optimize tables, if the process redefines the primary keys?
One table has a field that refers to the primary key of the other table. If the keys are redefined, the table will be wrong. |
Fri, Jun 30 2006 9:52 AM | Permanent Link |
"Ralf Mimoun" | Sanford Aranoff wrote:
> How can one optimize tables, if the process redefines the primary > keys? One table has a field that refers to the primary key of the > other table. If the keys are redefined, the table will be wrong. It does not redefine the primary keys or change any other data. It optimize a table using the primary index as the main factor. Ralf |
Fri, Jun 30 2006 4:28 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Sanford,
<< How can one optimize tables, if the process redefines the primary keys? One table has a field that refers to the primary key of the other table. If the keys are redefined, the table will be wrong. >> It doesn't change any primary key values, it simply re-orders the physical records according to the chosen index. This optimizes the read-ahead on the table using the most-often-used index (hopefully that is the index that you chose during the optimize), which can result in pretty good performance gains. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |