Stupid question that is a snake, I'm sure....

Just exactly how do I make/use an execution plan? Example would be great.

Thanks!

Lance

Lance,

From the manual:

Query Execution Plans
If you wish to retrieve a query execution plan for the current execution via the Plan
property, then set the
RequestPlan property to True before executing the query.
...
The following properties can only be interrogated after a query has been executed:
Property
Plan Contains information about how the current query was executed,
including any optimizations performed by ElevateDB. This
information is very useful in determining how to optimize a query
further or to simply figure out what ElevateDB is doing behind the
scenes. The Plan property is automatically cleared before each
execution of an SQL statement.
Note: Query plans are only generated for SQL SELECT, INSERT,
UPDATE, or DELETE statements.

Regards Uli

I was asleep in class when we covered that chapter...  lol

Thanks Uli...   I figured it was a snake.

I'm about to release my first EDB product so will try to see how my queries
are doing.

Lance



"Uli Becker" <test@test.com> wrote in message
news:C3B82D39-8841-4469-B6F6-B88476A5DA4D@news.elevatesoft.com...
> Lance,
>
> From the manual:
>
> Query Execution Plans
> If you wish to retrieve a query execution plan for the current execution
> via the Plan
> property, then set the
> RequestPlan property to True before executing the query.
> ..
> The following properties can only be interrogated after a query has been
> executed:
> Property
> Plan Contains information about how the current query was executed,
> including any optimizations performed by ElevateDB. This
> information is very useful in determining how to optimize a query
> further or to simply figure out what ElevateDB is doing behind the
> scenes. The Plan property is automatically cleared before each
> execution of an SQL statement.
> Note: Query plans are only generated for SQL SELECT, INSERT,
> UPDATE, or DELETE statements.
>
> Regards Uli
>

What's the Execution Plan worth, if it shows that my queries are already
optimized????    <grin>

Lance


"Lance Ras" <lance@cdesoftware.com> wrote in message
news:E64340CD-6075-4F2E-A000-B543DB3E3A80@news.elevatesoft.com...
> Stupid question that is a snake, I'm sure....
>
> Just exactly how do I make/use an execution plan? Example would be great.
>
> Thanks!
>
> Lance

<<
What's the Execution Plan worth, if it shows that my queries are already
optimized????    <grin>
>>

It just says: "I am proud of you..."

Uli

Uli


or go and have a coffee and relax

Roy Lambert

lol

Very cool.

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:0CC42663-48EB-49CE-8D2C-6AAC0639FD03@news.elevatesoft.com...
> Uli
>
>
> or go and have a coffee and relax
>
> Roy Lambert
>