Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 13 of 13 total |
slow query |
Wed, Jan 23 2008 7:04 PM | Permanent Link |
Pat | > it would be very helpful if you were to post the query
>plan. If you need help on how to generate one, just let me know. I would also like to know what it is/how to generate/benefits of a Query Plan. I looked at the help but nothing comes up under Query Plan. Pat |
Thu, Jan 24 2008 4:09 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Pat
In an app the property to set I believe is .GeneratePlan - its non visual. In DBSys there's a checkbox - Generate Plan In the app you'll need to access the output of the plan after the query has executed using the strings property Plan Roy Lambert |
Thu, Jan 24 2008 2:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Pat,
<< I would also like to know what it is/how to generate/benefits of a Query Plan. I looked at the help but nothing comes up under Query Plan. >> As Roy indicated, it's under the TDBISAMQuery Plan and GeneratePlan properties: http://www.elevatesoft.com/scripts/manual.dll?action=mancompprop&id=dbisam4&product=d&version=7&comp=TDBISAMQuery&prop=GeneratePlan http://www.elevatesoft.com/scripts/manual.dll?action=mancompprop&id=dbisam4&product=d&version=7&comp=TDBISAMQuery&prop=Plan -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |