testing for index used

zoeoberon · Post by **zoeoberon** » Wed Aug 03, 2005 4:17 pm

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.

Post by **John** » Thu Aug 04, 2005 10:48 am

The set verbose=1 should be what you want. The number you set verbose to is the same as the number of '-V' you give on the command line. What additional information are you seeing?

zoeoberon · Post by **zoeoberon** » Thu Aug 04, 2005 11:12 am

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:




















[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]
====================================================================

Post by **John** » Thu Aug 04, 2005 11:50 am

You can write a <putmsg> function ( http://thunderstone.master.com/texis/ma ... ch%3A&s=.2 ) to process the messages. The Vortex script is invoking SQL to do math and complex ifs, so they will show up as well.

Post by **mark** » Thu Aug 04, 2005 11:53 am

Only set verbose around the sql you want to see. Turn it off otherwise to not see sql used for math evaluation and such.

zoeoberon · Post by **zoeoberon** » Thu Aug 04, 2005 2:34 pm

thanks - a combination of the PUTMSG directive, a putmsg function and vxcp did the trick