HomeActive Query BuilderSQL SELECT Explain Plan

SQL SELECT Explain Plan


Hi,

can I perform an "EXPLAIN" function to get information about the access plan the database will use when executing the query such as how many i/o and table scans and so on.

This is most usefull to get understanding about how effective a given sql select statement is before executing it.

Very best Regards
Steen Jakobsen
DM Software

p.s. I'm using Oracle, SQLAnyWhere and SQLServer
Steen Jakobsen | email
February 17 2012, 06:15 AM
Active Query Builder does not execute neither EXPLAIN nor any other SQL queries. It is intended to parse and build SQL queries only.
Sergey Smagin | email
12 mins since original post
This topic is closed