<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 2/27/2011 1:58 AM, Chris Jones wrote:
<blockquote
cite="mid:AANLkTimugGk-gAM2GsnYMLg3racP0zS+KZ12nHyYEOFB@mail.gmail.com"
type="cite">What is the syntax to get use the "Explain" for a
query in VSQL?<br>
<br>
</blockquote>
Currently there is no such SQL syntax.<br>
Using vStudio you can turn on tune info and run the query as usual.
You will get a result and some sort of profiling info in the output
window. Also you can set "tune on" via SQL <br>
<br>
<span class="Apple-style-span" style="border-collapse: separate;
color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style:
normal; font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; font-size: medium;"><span
class="Apple-style-span" style="color: rgb(51, 51, 51);
font-family: Geneva,Arail,Helvetica,sans-serif; font-size: 12px;
line-height: 18px; text-align: justify;">
<pre class="code sql" style="padding: 0.5em; margin: 0px 0px 1em; font-size: 12px; border: 1px dashed rgb(204, 204, 204); color: rgb(51, 51, 51); overflow: auto; background-color: rgb(247, 249, 250); width: 701px;"><span class="kw1" style="padding: 0px; margin: 0px; color: rgb(177, 177, 0);">SET</span> PROPERTY <span class="search_hit" style="padding: 0px; margin: 0px; color: rgb(51, 51, 51); background-color: rgb(255, 255, 153);">Tune</span>Mode <span class="kw1" style="padding: 0px; margin: 0px; color: rgb(177, 177, 0);">TO</span> TRUE</pre>
</span></span>to get such info logged in the file (something like
Tunes_20101223_113551.log)<br>
<br>
See <a
href="http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:properties:vengine&s[]=tune">http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:properties:vengine&s[]=tune</a><br>
<br>
<pre class="moz-signature" cols="72">--
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
<a class="moz-txt-link-freetext" href="http://www.valentina-db.com">http://www.valentina-db.com</a></pre>
</body>
</html>