Using a single capitol -V on the command line with tsql I can get a few comments that quickly tell me what indexes are used. I'm trying to figure out how to get the same information from within a Vortex script. TRACESQL doesn't give information about indexes and <SQL "set verbose=1"> gives way too much information. What is the equivalent in Vortex to "-V" in tsql? Thanks.
Lines for SYSDUMMY that seem to be something with the results records? If this is the least number of messages I can get, then the next question is if I can capture this output somehow so I can then weed out the messages I want? Which looks like any line that doesn't reference SYSDUMMY.
====================================================================
From Vortex script:
<!-- Texis RDBMS Copyright (c) 1992 - 2005 Thunderstone - EPI, Inc. -->
<!-- Texis Web Script Copyright (c) 1996 - 2005 Thunderstone - EPI, Inc. -->
<!-- server=aprimesearchny1.ops.about.com indexsitesearch test db=lacms&sitename=hotbikeweb&terms=test -->
<!-- 200 /indexsitesearch:281: Setting pred <> A AND <> N on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:380: Setting pred 1= 1 AND = 1 on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:384: Setting pred <> AND 1<> 1 on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:468: Setting pred (lacms= pbmm OR lacms= wardsauto) on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:532: Setting pred = S AND <> on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:555: Setting pred -= - AND hotbikeweb<> on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:494: Setting pred Title\Keywords\Description\Content Proximate To 'test' AND Sitedirname= hotbikeweb on table sitecorpus in the function settablepred -->
<!-- 200 /indexsitesearch:494: Opening index /pirt-dl/lacms/index/xcorpus1 in the function ixfmmindex -->
<!-- 200 /indexsitesearch:500: Setting pred Title\Keywords\Description\Content Proximate To 'test' AND Sitedirname= hotbikeweb on table sitecorpus in the function settablepred -->
<!-- 200 /indexsitesearch:500: Opening index /pirt-dl/lacms/index/xcorpus1 in the function ixfmmindex -->
<!-- 200 /indexsitesearch:681: Setting pred 2>= 1+ 10 on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:681: Setting pred 3>= 1+ 10 on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:681: Setting pred 4>= 1+ 10 on table SYSDUMMY in the function settablepred -->
<!-- 200 /indexsitesearch:753: Setting pred (= y OR = f AND = ) on table SYSDUMMY in the function settablepred -->
[snip]
====================================================================
From TSQL:
aprimesearchny1: ~$ tsql -d /pirt-dl/lacms/index -V
Texis Version 05.01.1119555521(20050623) Copyright (c) 1988-2005 Thunderstone EPI
SQL 1>select Title, Description, Link, Sitedirname from sitecorpus where Title\Keywords\Description\Content likep 'test' and Sitedirname = 'hotbikeweb';
200 Setting pred Title\Keywords\Description\Content Proximate To 'test' AND Sitedirname= hotbikeweb on table sitecorpus in the function settablepred
200 Opening index /pirt-dl/lacms/index/xcorpus1 in the function ixfmmindex
Title Description Link Sitedirname
------------+------------+------------+------------+
Hot Bike's Top 5 Bikes of 2003 http://www.hotbikeweb.com/features/0401 ... index.html hotbikeweb
Harley-Davidson Softail Deluxe - Hot Bike Magazine The first of the year is always our favorite time on the calendar. It means it's time for the new models to start hitting the streets and time for us to test out the new rides -- as the old saying goes, http://www.hotbikeweb.com/features/0501 ... index.html hotbikeweb
Installing B&T's Smooth Ride Sportster shocks http://www.hotbikeweb.com/tech/0311hb_seat/index.html hotbikeweb
Sportster Fan -- Hot Bike Magazine http://www.hotbikeweb.com/itsmyturn/021 ... index.html hotbikeweb
Sportster Fan http://www.hotbikeweb.com/editorial/021 ... index.html hotbikeweb
Wakin' The Giant -- Hot Bike Magazine With a Little Stimulation from Head Quarters http://www.hotbikeweb.com/tech/0206hb_head/index.html hotbikeweb
Works Even When It's Idle -- Hot Bike Magazine http://www.hotbikeweb.com/tech/0212hb_oil/index.html hotbikeweb
[snip]
====================================================================
