|
Home > Archive > SQL Anywhere ultralite > April 2005 > Indexes in Ultralite
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Indexes in Ultralite
|
|
| Lucas Deby 2005-04-05, 8:03 pm |
| Hello,
I am having a problem with an ultralite table. The table will hold
approximately 50000 records. I created am using EVC 3.0 and targeting the
Pocket PC 2003 platform. I created an Item Select screen to query from this
table (it is an item table) and the query runs too slow ( I am using an
Intermec 700C device ARM255). Here is the table schema that I am using:
ALTER TABLE "AWADMIN"."FS_Item" ADD "ID" varchar(20) NOT NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "DescriptionEN" varchar(50) NOT NULL
DEFAULT '';
ALTER TABLE "AWADMIN"."FS_Item" ADD "TYPE" varchar(15) NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "UOM" varchar(6) NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "UPC" varchar(13) NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "SCC14" varchar(14) NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "PPU" numeric(12,4) NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "UNIT_PRICE" numeric(10,4) NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "DECIMAL_PLACES" numeric(1,0) NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "LAST_MODIFIED" "datetime" NOT NULL
DEFAULT GetDate(*);
ALTER TABLE "AWADMIN"."FS_Item" ADD "DELETED" bit NOT NULL DEFAULT 0;
ALTER TABLE "AWADMIN"."FS_Item" ADD "Time_Type" varchar(3) NULL;
ALTER TABLE "AWADMIN"."FS_Item" ADD "DescriptionFR" varchar(50) NOT NULL
DEFAULT '';
ALTER TABLE "AWADMIN"."FS_Item" ADD "TaxGroupID" varchar(20) NULL;
The primary key is the ID column.
My ultralite query looks like this:
SELECT
fs_item.id,
fs_item.DescriptionEN as ItemDescEN,
fs_item.DescriptionFR as ItemDescFR,
fs_item_type.IsTime,
fs_item_type.DescriptionEN as TypeDescEN,
fs_item_type.DescriptionFR as TypeDescFR,
fs_time_type.DescriptionEN as TimeTypeDescEN,
fs_time_type.DescriptionFR as TimeTypeDescFR
FROM
FS_item
left outer JOIN FS_item_type ON FS_item.type = FS_item_type.CODE
LEFT OUTER JOIN FS_time_TYPE ON FS_item.time_TYPE = FS_time_TYPE.code
WHERE
isnull(FS_item.type,'') like ?
and FS_item.id LIKE ?
and ((1 = ? and (FS_item.DescriptionEN LIKE ? )) OR
(1 = ? and (FS_item.DescriptionFR LIKE ? )))
and ((1 = ?) or (isInventory = ? and isTime = ?) or (isInventory = ?
and isTime = ?))
ORDER BY FS_item.ID
I tried adding additional indexes to the table with no success ie) Adding
indexes on DescriptionEN,Descri
ptionFR and Type didn't speed up my select
statement and it didn't change the size of my ultralite database. When I
pass in an item ID into this query it returns fairly quickly (since it's the
Primary key) but when I pass in a type, it takes much much longer (25
seconds versus 3 seconds). Adding an index doesn't seem to help.
Here are the additional indexes that I tried to create.
CREATE CLUSTERED INDEX "INDEX_DESCRIPTIONEN" ON "AWADMIN"."FS_Item" (
"DescriptionEN" ASC ) IN "SYSTEM";
CREATE INDEX "INDEX_DESCRIPTIONFR" ON "AWADMIN"."FS_Item" ( "DescriptionFR"
ASC ) IN "SYSTEM";
CREATE INDEX "INDEX_ITEM_TYPE" ON "AWADMIN"."FS_Item" ( "TYPE" ASC ) IN
"SYSTEM";
I am using:
Adaptive Server Anywhere 9 9.0.2.2551
MobiLink Synchronization 9 9.0.2.2551
Any help on how to get these indexes working with my ultralite database
would be much appreciated.
Thank you,
Lucas Deby
| |
| Tom Slee 2005-04-12, 1:23 pm |
| Can I just clarify something? I assume that this is an embedded SQL
application, and that the statements are ones that you execute against
your reference database?
Tom Slee
Lucas Deby wrote:
> Hello,
>
> I am having a problem with an ultralite table. The table will hold
> approximately 50000 records. I created am using EVC 3.0 and targeting the
> Pocket PC 2003 platform. I created an Item Select screen to query from this
> table (it is an item table) and the query runs too slow ( I am using an
> Intermec 700C device ARM255). Here is the table schema that I am using:
>
> ALTER TABLE "AWADMIN"."FS_Item" ADD "ID" varchar(20) NOT NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "DescriptionEN" varchar(50) NOT NULL
> DEFAULT '';
> ALTER TABLE "AWADMIN"."FS_Item" ADD "TYPE" varchar(15) NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "UOM" varchar(6) NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "UPC" varchar(13) NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "SCC14" varchar(14) NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "PPU" numeric(12,4) NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "UNIT_PRICE" numeric(10,4) NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "DECIMAL_PLACES" numeric(1,0) NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "LAST_MODIFIED" "datetime" NOT NULL
> DEFAULT GetDate(*);
> ALTER TABLE "AWADMIN"."FS_Item" ADD "DELETED" bit NOT NULL DEFAULT 0;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "Time_Type" varchar(3) NULL;
> ALTER TABLE "AWADMIN"."FS_Item" ADD "DescriptionFR" varchar(50) NOT NULL
> DEFAULT '';
> ALTER TABLE "AWADMIN"."FS_Item" ADD "TaxGroupID" varchar(20) NULL;
>
> The primary key is the ID column.
>
> My ultralite query looks like this:
>
> SELECT
> fs_item.id,
> fs_item.DescriptionEN as ItemDescEN,
> fs_item.DescriptionFR as ItemDescFR,
> fs_item_type.IsTime,
> fs_item_type.DescriptionEN as TypeDescEN,
> fs_item_type.DescriptionFR as TypeDescFR,
> fs_time_type.DescriptionEN as TimeTypeDescEN,
> fs_time_type.DescriptionFR as TimeTypeDescFR
> FROM
> FS_item
> left outer JOIN FS_item_type ON FS_item.type = FS_item_type.CODE
> LEFT OUTER JOIN FS_time_TYPE ON FS_item.time_TYPE = FS_time_TYPE.code
> WHERE
> isnull(FS_item.type,'') like ?
> and FS_item.id LIKE ?
> and ((1 = ? and (FS_item.DescriptionEN LIKE ? )) OR
> (1 = ? and (FS_item.DescriptionFR LIKE ? )))
> and ((1 = ?) or (isInventory = ? and isTime = ?) or (isInventory = ?
> and isTime = ?))
> ORDER BY FS_item.ID
>
> I tried adding additional indexes to the table with no success ie) Adding
> indexes on DescriptionEN,Descri
ptionFR and Type didn't speed up my select
> statement and it didn't change the size of my ultralite database. When I
> pass in an item ID into this query it returns fairly quickly (since it's the
> Primary key) but when I pass in a type, it takes much much longer (25
> seconds versus 3 seconds). Adding an index doesn't seem to help.
>
> Here are the additional indexes that I tried to create.
>
> CREATE CLUSTERED INDEX "INDEX_DESCRIPTIONEN" ON "AWADMIN"."FS_Item" (
> "DescriptionEN" ASC ) IN "SYSTEM";
> CREATE INDEX "INDEX_DESCRIPTIONFR" ON "AWADMIN"."FS_Item" ( "DescriptionFR"
> ASC ) IN "SYSTEM";
> CREATE INDEX "INDEX_ITEM_TYPE" ON "AWADMIN"."FS_Item" ( "TYPE" ASC ) IN
> "SYSTEM";
>
>
> I am using:
>
> Adaptive Server Anywhere 9 9.0.2.2551
>
> MobiLink Synchronization 9 9.0.2.2551
>
>
>
> Any help on how to get these indexes working with my ultralite database
> would be much appreciated.
>
> Thank you,
> Lucas Deby
>
>
| |
| Lucas Deby 2005-04-13, 9:23 am |
| Hello Tom,
Thank you for replying.
What I have is a Sybase consolidated database running on a server. I added
the indexes to the consolidated db and then ran the ulgen.exe utility to
generate 3 files; FieldServiceDB.cpp, FieldServiceDB.h and
FieldServiceDB.hpp. I then included these files in my application, build it
with EVC 3.0 and sent it to the Handheld using ActiveSync. On the handheld,
I do not have ASA (for windows ce) installed. The generated 'C class'
accesses my ultralite database automatically from within my compiled
application without any other ASA files. The speed problem is on the remote
database (the one on my handheld device) ie) I sync my handheld database
with the consolidated and then I try to access items on the remote
(handheld) database and this process is slow.
I hope that this answers your question, I'm not sure if my code would
qualify as being embedded sql and I'm guessing that by 'reference db' you
mean the remote ultralite db that resides on the handheld. Please let me
know if you need more info.
Here is some of my C code used to access the ultralite db on the handheld:
(this function runs this query
SELECT
count(fs_item.id) as cnt
FROM
FS_item
left outer JOIN FS_item_type ON FS_item.type = FS_item_type.CODE
WHERE isnull(FS_item.type,'') like ?
and FS_item.id LIKE ?
and ((1 = ? and (FS_item.DescriptionEN LIKE ? )) OR (1 = ? and
(FS_item.DescriptionFR LIKE ? )) )
and ((1 = ?) or (isInventory = ? and isTime = ?) or (isInventory = ?
and isTime = ?))
/ ********************
********************
********************
***************
**
FUNCTION: CountAllItems
FUNCTIONAL DESCRIPTION:
Counts items when 'All' items radio button is chosen, sets the listview
size parameter to the item count.
FORMAL ARGUMENTS:
None
RETURN VALUES:
None
********************
********************
********************
****************
**/
long CSelectItem::CountAl
lItems() {
SELCountAllItems rsItems;
bool bout;
long nCount=0;
short sLangFR,sLangEN;
CString csDescFR = m_csDescFilter;
m_csLangCode.MakeLower();
if(m_csLangCode == _T("en")) {
sLangEN = 1;
sLangFR = 0;
} else {
sLangEN = 0;
sLangFR = 1;
}
//Open the recordset with the WO
rsItems. Open(CDataRetrieve::
GetConnection(),
m_csItemTypeFilter. GetBuffer(m_csItemTy
peFilter.GetLength()),
m_csIDFilter. GetBuffer(m_csIDFilt
er.GetLength()),
sLangEN,
m_csDescFilter. GetBuffer(m_csDescFi
lter.GetLength()),
sLangFR,
csDescFR.GetBuffer(csDescFR.GetLength()),
m_cSetIsEverything,
m_cSetIsInv1,
m_cSetIsTime1,
m_cSetIsInv2,
m_cSetIsTime2);
m_csLangCode.ReleaseBuffer();
m_csDescFilter.ReleaseBuffer();
m_csIDFilter.ReleaseBuffer();
m_csItemTypeFilter.ReleaseBuffer();
if ( rsItems.First()) { // return count
rsItems.GetCnt(nCount,&bout );
}
rsItems.Close();
return nCount;
}
"Tom Slee" <tom.slee@sybase.com> wrote in message
news:425c1478@forums
-2-dub...[color=darkred]
> Can I just clarify something? I assume that this is an embedded SQL
> application, and that the statements are ones that you execute against
> your reference database?
>
> Tom Slee
>
> Lucas Deby wrote:
the[color=darkred]
this[color=darkred]
FS_time_TYPE.code[color=darkred]
= ?[color=darkred]
Adding[color=darkred
]
select[color=darkred
]
I[color=darkred]
the[color=darkred]
"DescriptionFR"[color=darkred]
| |
| David Fishburn 2005-04-13, 9:23 am |
| "Lucas Deby" <Lucas_Deby@ApexSI.com> wrote in
news:425d1ad0$1@foru
ms-1-dub of sybase.public.sqlanywhere.ultralite:
When you run this query in DBISQL, have you looked at the ULPlan to see
what plan it will use?
Also, you can run ulgen -l short|long|xml which will show the plan UL
will use for each of the statements.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Lucas Deby 2005-04-18, 8:23 pm |
| I generated the plan for the query and viewed it in ASA, How can I use this
to see if my indexing is correct. Here is the XML file for my query:
<?xml version="1.0"?>
<!DOCTYPE asaplan>
<asaPlan ASAversion="8.0">
<originalquery>
<![CDATA[SELECT
fs_item.id,
fs_item.DescriptionEN as ItemDescEN,
fs_item.DescriptionFR as ItemDescFR,
fs_item_type.IsTime,
fs_item_type.DescriptionEN as TypeDescEN,
fs_item_type.DescriptionFR as TypeDescFR,
fs_time_type.DescriptionEN as TimeTypeDescEN,
fs_time_type.DescriptionFR as TimeTypeDescFR
FROM
FS_item
left outer JOIN FS_item_type ON FS_item.type = FS_item_type.CODE
LEFT OUTER JOIN FS_time_TYPE ON FS_item.time_TYPE = FS_time_TYPE.code
WHERE
isnull(FS_item.type,'') like ?
and FS_item.id LIKE ?
and ((1 = ? and (FS_item.DescriptionEN LIKE ? )) OR
(1 = ? and (FS_item.DescriptionFR LIKE ? )))
and ((1 = ?) or (isInventory = ? and isTime = ?) or (isInventory = ?
and isTime = ?))
ORDER BY FS_item.ID]]>
</originalquery>
<query name="Main Query" isSubquery="false">
<operator ltype="Select" ptype="Select" materialized="false" percentCost="0"
rowCount="0" runtime="0" subQueries="" lname="Select" sname="SELECT"
name="SELECT">
<tooltip>
<![CDATA[<font color="#000000"><center><font
size=+1>SELECT</font></center><p><table cellspacing=0 cellpadding=0
color="#000000">
<tr><th ALIGN=left>Estimates<td> <th ALIGN=left>Node
Statistics<td> <th ALIGN=left>Subtree Statistics<td>
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>100
<tr><td><b>RowsReturned</b><td><td>0.14691
<tr><td><b>RunTime</b><td><td>0<td><td>0.0072393</table></p></font>]]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>SELECT</font><br>
<pre>SELECT
fs_item.id,
fs_item.DescriptionEN as ItemDescEN,
fs_item.DescriptionFR as ItemDescFR,
fs_item_type.IsTime,
fs_item_type.DescriptionEN as TypeDescEN,
fs_item_type.DescriptionFR as TypeDescFR,
fs_time_type.DescriptionEN as TimeTypeDescEN,
fs_time_type.DescriptionFR as TimeTypeDescFR
FROM
FS_item
left outer JOIN FS_item_type ON FS_item.type = FS_item_type.CODE
LEFT OUTER JOIN FS_time_TYPE ON FS_item.time_TYPE = FS_time_TYPE.code
WHERE
isnull(FS_item.type,'') like ?
and FS_item.id LIKE ?
and ((1 = ? and (FS_item.DescriptionEN LIKE ? )) OR
(1 = ? and (FS_item.DescriptionFR LIKE ? )))
and ((1 = ?) or (isInventory = ? and isTime = ?) or (isInventory = ?
and isTime = ?))
ORDER BY FS_item.ID</pre><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Node Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>Run time as a percent of
total query time
<tr><td><b>RunTime</b><td><td>0<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to
disk</table></p><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Subtree Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>100<td><td>Run time as a percent of
total query time
<tr><td><b>RunTime</b><td><td>0.0072393<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0.0072393<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Optimizer statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Value<td> <th
ALIGN=left>Description<td>
<tr><td><b>Costed subplans</b><td><td>5<td><td>Number of different
enumeration strategies considered by the optimizer
<tr><td><b>Estimated cache pages</b><td><td>9658<td><td>Estimated cache
pages available for this statement
<tr><td><b>CurrentCacheSize</b><td><td>40404<td><td>Current cache size in
kilobytes
<tr><td><b>Isolation_level</b><td><td>0<td><td>Controls the locking
isolation level
<tr><td><b>Optimization_goal</b><td><td>All-rows<td><td>Optimize queries for
first row or all rows
<tr><td><b>Optimization_level</b><td><td>9<td><td>Reserved
<tr><td><b> Optimization_workloa
d</b><td><td>Mixed<td><td>Controls whether
optimizing for OLAP or mixed queries
<tr><td><b>ProductVersion</b><td><td>9.0.2.2551<td><td>Product version
<tr><td><b>User_estimates</b><td><td>Override-magic<td><td>Controls whether
to respect user estimates</table></p><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Select list</font></b>
<tr><td>FS_Item.ID<td><td>varchar(20)
<tr><td>FS_Item.DescriptionEN<td><td>varchar(50)
<tr><td>FS_Item.DescriptionFR<td><td>varchar(50)
<tr><td>FS_Item_Type.ISTIME<td><td>bit
<tr><td>FS_Item_Type.DescriptionEN<td><td>varchar(20)
<tr><td>FS_Item_Type.DescriptionFR<td><td>varchar(20)
<tr><td>FS_Time_Type.DescriptionEN<td><td>varchar(20)
<tr><td>FS_Time_Type.DescriptionFR<td><td>varchar(20)</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Options</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Value<td> <th
ALIGN=left>Description<td>
<tr><td><b>Alias</b><td><td>FieldServicev22<td><td>Mounted database name
<tr><td><b>Ansi_blanks</b><td><td>Off<td><td>Controls truncation errors
<tr><td><b> Ansi_integer_overflo
w</b><td><td>Off<td><td>Controls whether
integer overflow causes an error
<tr><td><b> Ansi_update_constrai
nts</b><td><td>Cursors<td><td>Controls the
range of updates that are permitted
<tr><td><b>Ansinull</b><td><td>On<td><td>Controls interpretation of NULL
values
<tr><td><b>BlankPadding</b><td><td>OFF<td><td>Blank padding
<tr><td><b>BlobArenas</b><td><td>ON<td><td>Blob extension pages are stored
separately from table pages
<tr><td><b>Blocking</b><td><td>On<td><td>Controls response to locking
conflicts
<tr><td><b>Capabilities</b><td><td>41BFFFDD<td><td>Database capability bits
<tr><td><b>CaseSensitive</b><td><td>OFF<td><td>Case sensitivity
<tr><td><b>CharSet</b><td><td>cp1252<td><td>Character Set
<tr><td><b>Checksum</b><td><td>OFF<td><td>Page checksum
<tr><td><b>ClusteredIndexes</b><td><td>ON<td><td>Clustered indexes
<tr><td><b>Collation</b><td><td>1252LATIN1<td><td>Collation name
<tr><td><b>CommandLine</b><td><td> c:\db\FieldServicev2
2\FieldServicev22.db -
o c:\db\FieldServicev2
2\FieldServicev22Out
Put.log -os 5000000
<td><td>Expanded command line used to start the server
<tr><td><b>CompressedBTrees</b><td><td>ON<td><td>Compressed B-Tree indexes
are supported
<tr><td><b>Compression</b><td><td>OFF<td><td>Compression enabled
<tr><td><b>Conversion_error</b><td><td>On<td><td>Controls datatype
conversion errors
<tr><td><b>Date_format</b><td><td>YYYY-MM-DD<td><td>Controls format for DATE
values
<tr><td><b>Date_order</b><td><td>YMD<td><td>Controls order of date
components
<tr><td><b>DBFileFragments</b><td><td>1408<td><td>Database file fragments
<tr><td><b>DefaultCollation</b><td><td>1252LATIN1<td><td>Default Collation
<tr><td><b> Divide_by_zero_error
</b><td><td>On<td><td>Controls divide-by-zero
errors
<tr><td><b>DriveType</b><td><td>FIXED<td><td>Drive type where the database
is located
<tr><td><b>Encryption</b><td><td>None<td><td>Encryption type
<tr><td><b> Extended_join_syntax
</b><td><td>On<td><td>Controls errors when
using duplicate correlation names in joins
<tr><td><b>File</b><td><td> c:\db\FieldServicev2
2\FieldServicev22.db<td><td>D
atabase file
<tr><td><b>FileSize</b><td><td>20333<td><td>File size in pages
<tr><td><b>FileVersion</b><td><td>41<td><td>Database file version number
<tr><td><b>FreePageBitMaps</b><td><td>ON<td><td>Free database pages managed
via bitmaps
<tr><td><b>FreePages</b><td><td>1571<td><td>Number of free pages in dbspace
<tr><td><b>HistogramHashFix</b><td><td>OFF<td><td>Fixed histogram hash
implementation
<tr><td><b>Histograms</b><td><td>ON<td><td>Optimizer statistics maintained
as histograms
<tr><td><b>IndexStatistics</b><td><td>OFF<td><td>Index Statistics
<tr><td><b>IsJavaAvailable</b><td><td>NO<td><td>Java available
<tr><td><b>JavaObjectsEnabled</b><td><td>NO<td><td>Java objects enabled
<tr><td><b>IsNetworkServer</b><td><td>YES<td><td>Is Network Server
<tr><td><b>IsRuntimeServer</b><td><td>NO<td><td>Is Runtime Server
<tr><td><b>Language</b><td><td>us_english<td><td>
<tr><td><b>LicenseCount</b><td><td>1<td><td>Number of licensed seats
<tr><td><b>LicensedCompany</b><td><td>APEX<td><td>Name of the licensed
company
<tr><td><b>LicensedUser</b><td><td>APEX<td><td>Name of the licensed user
<tr><td><b>LicenseType</b><td><td>cpu-based<td><td>License type
<tr><td><b>LivenessTimeout</b><td><td>120<td><td>Client liveness timeout
default
<tr><td><b>LogFileFragments</b><td><td>3487<td><td>Log file fragments
<tr><td><b>MachineName</b><td><td>DOTNET<td><td>Name of the machine
<tr><td><b>MainHeapBytes</b><td><td>4294912128<td><td>Main heap bytes in
cache
<tr><td><b>Max_plans_cached</b><td><td>20<td><td>Maximum number of cached
execution plans for a connection
<tr><td><b>MaxCacheSize</b><td><td>262144<td><td>Maximum cache size in
kilobytes
<tr><td><b>MinCacheSize</b><td><td>2048<td><td>Minimum cache size in
kilobytes
<tr><td><b>MultiByteCharSet</b><td><td>OFF<td><td>Multi Byte Character Set
( on/off )
<tr><td><b>Name</b><td><td>FieldServicev22<td><td>
<tr><td><b>NamedConstraints</b><td><td>OFF<td><td>Named Constraints
<tr><td><b>NumProcessorsAvail</b><td><td>1<td><td>Number of processors on
server
<tr><td><b>NumProcessorsMax</b><td><td>1<td><td>Maximum number of processors
used
<tr><td><b>PageSize</b><td><td>2048<td><td>Database page size
<tr><td><b>PeakCacheSize</b><td><td>40404<td><td>Peak cache size in
kilobytes
<tr><td><b>Platform</b><td><td>Windows2000<td><td>Operating system platform
<tr><td><b>PlatformVer</b><td><td>Windows 2000 Build 2195 Service Pack
4<td><td>Operating system platform version
<tr><td><b>Precision</b><td><td>30<td><td>Maximum number of digits in
decimal arithmetic
<tr><td><b>Prefetch</b><td><td>On<td><td>Controls prefetching of rows
<tr><td><b>ProcedureProfiling</b><td><td>OFF<td><td>Procedure profiling
<tr><td><b> ProcessorArchitectur
e</b><td><td>X86<td><td>Processor
architecture
<tr><td><b>ReadOnly</b><td><td>OFF<td><td>Database read-only mode
<tr><td><b>RequestLogging</b><td><td>NONE<td><td>Request logging
<tr><td><b>Row_counts</b><td><td>Off<td><td>Controls whether row counts are
estimates or exact
<tr><td><b>Scale</b><td><td>6<td><td>Minimum number of digits after decimal
point
<tr><td><b> SeparateCheckpointLo
g</b><td><td>ON<td><td>Checkpoint log
maintained at end of system dbspace
<tr><td><b>SeparateForeignKeys</b><td><td>ON<td><td>Primary and foreign key
indexes are stored separately
<tr><td><b>StartTime</b><td><td>2005-04-11 15:03:39.193<td><td>Server start
time
<tr><td><b>String_rtruncation</b><td><td>Off<td><td>Controls truncation
errors on INSERT or UPDATE
<tr><td><b>StringHistogramsFix</b><td><td>ON<td><td>Fixed string histograms
implementation
<tr><td><b>TableBitMaps</b><td><td>ON<td><td>Table bit maps supported
<tr><td><b>TempDir</b><td><td>C:\WINNT\TEMP<td><td>Temporary directory
<tr><td><b>TempFileName</b><td><td> C:\WINNT\TEMP\asat00
01.tmp<td><td>Databas
e temporary file name
<tr><td><b>Threads</b><td><td>20<td><td>Server thread count
<tr><td><b>Time_format</b><td><td>HH:NN:SS.SSS<td><td>Controls format for
TIME values
<tr><td><b>Timestamp_format</b><td><td>YYYY-MM-DD
HH:NN:SS.SSS<td><td>Controls format for TIMESTAMP values
<tr><td><b>Update_statistics</b><td><td>On<td><td>Controls recording of
statistics during query execution
<tr><td><b>Userid</b><td><td>admin<td><td>User ID
<tr><td><b>VariableHashSize</b><td><td>ON<td><td>Hash length may be
specified for BTree indexes</table></p></font>]]>
</details>
<operator ltype="Lock" ptype="Lock" materialized="false" subQueries=""
lname="Lock" sname="Lock" name="Lock">
<tooltip>
<![CDATA[<font color="#000000"><center><font size=+1>Lock</font><br>
Lock FS_Item_Type, isolation level 0<br>
Lock FS_Time_Type, isolation level 0<br>
Lock FS_Item, isolation level 0</center></font>]]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>Lock</font><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font size=+1>Locked
tables</font></b>
<tr><td>Lock FS_Item_Type, isolation level 0
<tr><td>Lock FS_Time_Type, isolation level 0
<tr><td>Lock FS_Item, isolation level 0</table></p></font>]]>
</details>
<operator ltype="Filter" ptype="Filter" materialized="false" percentCost="0"
rowCount="0" runtime="0" subQueries="" lname="Filter" sname="Filter"
name="Filter">
<tooltip>
<![CDATA[<font color="#000000"><center><font
size=+1>Filter</font></center><p><table cellspacing=0 cellpadding=0
color="#000000">
<tr><th ALIGN=left>Estimates<td> <th ALIGN=left>Node
Statistics<td> <th ALIGN=left>Subtree Statistics<td>
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>100
<tr><td><b>RowsReturned</b><td><td>0.14691
<tr><td><b>RunTime</b><td><td>0<td><td>0.0072393</table></p></font>]]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>Filter</font><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font size=+1>Node
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>Run time as a percent of
total query time
<tr><td><b>RunTime</b><td><td>0<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to
disk</table></p><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Subtree Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>100<td><td>Run time as a percent of
total query time
<tr><td><b>RunTime</b><td><td>0.0072393<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0.0072393<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Predicate</font></b>
<tr><td>( ( FS_Item_Type.ISINVENTORY = expr( 9, NULL, 0 ) : 97.647%
Column ) AND ( FS_Item_Type.ISTIME = expr( 10, NULL, 0 ) : 99.425%
Column ) ) OR ( ( FS_Item_Type.ISINVENTORY = expr( 7, NULL, 0 ) : 97.647%
Column ) AND ( FS_Item_Type.ISTIME = expr( 8, NULL, 0 ) : 99.425%
Column ) ) OR ( 1 = expr( 6, NULL, 0 ) : 5% Guess ) : 100%
Combined</table></p></font>]]>
</details>
<operator ltype="Join" ptype="NestedLoopsJoin" materialized="false"
percentCost="0.0050736" rowCount="0" runtime="3.6729e-007" subQueries=""
lname="NestedLoopsJoin" sname="JNLO" name="Left Outer Nested Loops Join">
<tooltip>
<![CDATA[<font color="#000000"><center><font size=+1>Left Outer Nested Loops
Join</font><br>
partly materialized<br>
left outer join</center><p><table cellspacing=0 cellpadding=0
color="#000000">
<tr><th ALIGN=left>Estimates<td> <th ALIGN=left>Node
Statistics<td> <th ALIGN=left>Subtree Statistics<td>
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>100
<tr><td><b>RowsReturned</b><td><td>0.14691
<tr><td><b>RunTime</b><td><td>3.6729e-007<td><td>0.0072393</table></p></font
>]]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>Left Outer Nested Loops Join
(left outer join)</font><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Predicate</font></b>
<tr><td>TRUE</table></p><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Node Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0.0050736<td><td>Run time as a
percent of total query time
<tr><td><b>RunTime</b><td><td>3.6729e-007<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>3.6729e-007<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font size=+1>Subtree
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>100<td><td>Run time as a percent of
total query time
<tr><td><b>RunTime</b><td><td>0.0072393<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0.0072393<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Predicate</font></b>
<tr><td>TRUE</table></p>]]>
</details>
<operator ltype="Join" ptype="NestedLoopsJoin" materialized="false"
percentCost="0.0050712" rowCount="0" runtime="3.6712e-007" subQueries=""
lname="NestedLoopsJoin" sname="JNLO" name="Left Outer Nested Loops Join">
<tooltip>
<![CDATA[<font color="#000000"><center><font size=+1>Left Outer Nested Loops
Join</font><br>
partly materialized<br>
left outer join</center><p><table cellspacing=0 cellpadding=0
color="#000000">
<tr><th ALIGN=left>Estimates<td> <th ALIGN=left>Node
Statistics<td> <th ALIGN=left>Subtree Statistics<td>
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>99
<tr><td><b>RowsReturned</b><td><td>0.14691
<tr><td><b>RunTime</b><td><td>3.6712e-007<td><td>0.0072315</table></p></font
>]]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>Left Outer Nested Loops Join
(left outer join)</font><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Predicate</font></b>
<tr><td>TRUE</table></p><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Node Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0.0050712<td><td>Run time as a
percent of total query time
<tr><td><b>RunTime</b><td><td>3.6712e-007<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>3.6712e-007<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font size=+1>Subtree
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>99.893<td><td>Run time as a percent
of total query time
<tr><td><b>RunTime</b><td><td>0.0072315<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0.0072315<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Predicate</font></b>
<tr><td>TRUE</table></p>]]>
</details>
<operator ltype="Filter" ptype="Filter" materialized="false" percentCost="0"
rowCount="0" runtime="0" subQueries="" lname="Filter" sname="Filter"
name="Filter">
<tooltip>
<![CDATA[<font color="#000000"><center><font
size=+1>Filter</font></center><p><table cellspacing=0 cellpadding=0
color="#000000">
<tr><th ALIGN=left>Estimates<td> <th ALIGN=left>Node
Statistics<td> <th ALIGN=left>Subtree Statistics<td>
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>99
<tr><td><b>RowsReturned</b><td><td>0.14691
<tr><td><b>RunTime</b><td><td>0<td><td>0.0072261</table></p></font>]]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>Filter</font><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font size=+1>Node
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>Run time as a percent of
total query time
<tr><td><b>RunTime</b><td><td>0<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to
disk</table></p><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Subtree Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.14691<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>99.819<td><td>Run time as a percent
of total query time
<tr><td><b>RunTime</b><td><td>0.0072261<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0.0072261<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Predicate</font></b>
<tr><td>expr( FS_Item.TYPE, '' ) < expr( 0, NULL, 0, NULL ) : 25%
Guess
<tr><td>expr( FS_Item.TYPE, '' ) >= expr( 0, NULL, 0, NULL ) : 25%
Guess
<tr><td>( ( 1 = expr( 4, NULL, 0 ) : 5% Guess ) AND (
FS_Item.DescriptionFR >= expr( 5, NULL, 0, NULL ) : 25% Guess ) AND
( FS_Item.DescriptionFR < expr( 5, NULL, 0, NULL ) : 25% Guess ) AND
( FS_Item.DescriptionFR LIKE expr( 5, NULL, 0 ) : 50% Guess ) ) OR ( ( 1
= expr( 2, NULL, 0 ) : 5% Guess ) AND ( FS_Item.DescriptionEN >=
expr( 3, NULL, 0, NULL ) : 25% Guess ) AND ( FS_Item.DescriptionEN <
expr( 3, NULL, 0, NULL ) : 25% Guess ) AND ( FS_Item.DescriptionEN LIKE
expr( 3, NULL, 0 ) : 50% Guess ) ) : 0.3125% Guess
<tr><td>FS_Item.ID LIKE expr( 1, NULL, 0 ) : 50% Guess
<tr><td>expr( FS_Item.TYPE, '' ) LIKE expr( 0, NULL, 0 ) : 50%
Guess</table></p></font>]]>
</details>
<operator ltype="Scan" ptype="IndexScan" materialized="false"
percentCost="99.819" rowCount="2888" runtime="0.0072261" subQueries=""
lname="IndexScan" name="FS_Item" sname="FS_Item">
<tooltip>
<![CDATA[<font color="#000000"><center><font size=+1>Index Scan</font><br>
partly materialized<br>
Scan FS_Item using index FS_Item</center><p><table cellspacing=0
cellpadding=0 color="#000000">
<tr><th ALIGN=left>Estimates<td> <th ALIGN=left>Node
Statistics<td> <th ALIGN=left>Subtree Statistics<td>
<tr><td><b>PercentTotalCost</b><td><td>99<td><td>99
<tr><td><b>RowsReturned</b><td><td>2888.5
<tr><td><b>RunTime</b><td><td>0.0072261<td><td>0.0072261</table></p></font>]
]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>Index Scan</font><br>
Scan FS_Item using index FS_Item<p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Table reference</font></b>
<tr><td><b>Table name</b><td><td>FS_Item
<tr><td><b>Estimated rows</b><td><td>48141
<tr><td><b>Estimated pages</b><td><td>2609
<tr><td><b>Estimated pages in cache</b><td><td>2609
<tr><td><b>Estimated row size (bytes)</b><td><td>200
<tr><td><b>Page map</b><td><td>yes
<tr><td><b>Buffer fetch</b><td><td>no
<tr><td><b>Relax cursor stability</b><td><td>no</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Index</font></b>
<tr><td><b>Index name</b><td><td>FS_Item
<tr><td><b>Key type</b><td><td>primary key
<tr><td><b>Clustered index</b><td><td>no
<tr><td><b>Depth</b><td><td>2
<tr><td><b>Estimated leaf pages</b><td><td>220</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Scan</font></b>
<tr><td><b>Selectivity</b><td><td>6.00000% Guess
<tr><td><b>Direction</b><td><td>forward
<tr><td> expr( 1, NULL, 0, NULL ) <= ID < expr( 1, NULL, 0,
NULL ) ASC</table></p><p><table cellspacing=0 cellpadding=0
color="#000000"><tr><td><b><font size=+1>Node Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>2888.5<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>99.819<td><td>Run time as a percent
of total query time
<tr><td><b>RunTime</b><td><td>0.0072261<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0.0072261<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font size=+1>Subtree
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>2888.5<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>99.819<td><td>Run time as a percent
of total query time
<tr><td><b>RunTime</b><td><td>0.0072261<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>0.0072261<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p></font>]]>
</details>
</operator>
</operator>
<operator ltype="Scan" ptype="IndexScan" materialized="false"
percentCost="0.069096" rowCount="0" runtime="5.002e-006" subQueries=""
lname="IndexScan" name="FS_Time_Type" sname="FS_Time_Type">
<tooltip>
<![CDATA[<font color="#000000"><center><font size=+1>Index Scan</font><br>
partly materialized<br>
Scan FS_Time_Type using index FS_Time_Type</center><p><table cellspacing=0
cellpadding=0 color="#000000">
<tr><th ALIGN=left>Estimates<td> <th ALIGN=left>Node
Statistics<td> <th ALIGN=left>Subtree Statistics<td>
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>0
<tr><td><b>RowsReturned</b><td><td>0.00081012
<tr><td><b>RunTime</b><td><td>5.002e-006<td><td>5.002e-006</table></p></font
>]]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>Index Scan</font><br>
Scan FS_Time_Type using index FS_Time_Type<p><table cellspacing=0
cellpadding=0 color="#000000"><tr><td><b><font size=+1>Table
reference</font></b>
<tr><td><b>Table name</b><td><td>FS_Time_Type
<tr><td><b>Estimated rows</b><td><td>3
<tr><td><b>Estimated pages</b><td><td>1
<tr><td><b>Estimated pages in cache</b><td><td>1
<tr><td><b>Estimated row size (bytes)</b><td><td>59
<tr><td><b>Page map</b><td><td>no
<tr><td><b>Buffer fetch</b><td><td>no
<tr><td><b>Relax cursor stability</b><td><td>no</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Index</font></b>
<tr><td><b>Index name</b><td><td>FS_Time_Type
<tr><td><b>Key type</b><td><td>primary key
<tr><td><b>Clustered index</b><td><td>no
<tr><td><b>Depth</b><td><td>1
<tr><td><b>Estimated leaf pages</b><td><td>1</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Scan</font></b>
<tr><td><b>Selectivity</b><td><td>0.02700% Column-Column
<tr><td><b>Direction</b><td><td>forward
<tr><td>Code = FS_Item.Time_Type ASC</table></p><p><table cellspacing=0
cellpadding=0 color="#000000"><tr><td><b><font size=+1>Node
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.00081012<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0.069096<td><td>Run time as a percent
of total query time
<tr><td><b>RunTime</b><td><td>5.002e-006<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>5.002e-006<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font size=+1>Subtree
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.00081012<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0.069096<td><td>Run time as a percent
of total query time
<tr><td><b>RunTime</b><td><td>5.002e-006<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>5.002e-006<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p></font>]]>
</details>
</operator>
</operator>
<operator ltype="Scan" ptype="IndexScan" materialized="false"
percentCost="0.10214" rowCount="0" runtime="7.3944e-006" subQueries=""
lname="IndexScan" name="FS_Item_Type" sname="FS_Item_Type">
<tooltip>
<![CDATA[<font color="#000000"><center><font size=+1>Index Scan</font><br>
partly materialized<br>
Scan FS_Item_Type using index FS_Item_Type</center><p><table cellspacing=0
cellpadding=0 color="#000000">
<tr><th ALIGN=left>Estimates<td> <th ALIGN=left>Node
Statistics<td> <th ALIGN=left>Subtree Statistics<td>
<tr><td><b>PercentTotalCost</b><td><td>0<td><td>0
<tr><td><b>RowsReturned</b><td><td>0.95777
<tr><td><b>RunTime</b><td><td>7.3944e-006<td><td>7.3944e-006</table></p></fo
nt>]]>
</tooltip>
<details>
<![CDATA[<font color="#000000"><font size=+2>Index Scan</font><br>
Scan FS_Item_Type using index FS_Item_Type<p><table cellspacing=0
cellpadding=0 color="#000000"><tr><td><b><font size=+1>Table
reference</font></b>
<tr><td><b>Table name</b><td><td>FS_Item_Type
<tr><td><b>Estimated rows</b><td><td>175
<tr><td><b>Estimated pages</b><td><td>6
<tr><td><b>Estimated pages in cache</b><td><td>6
<tr><td><b>Estimated row size (bytes)</b><td><td>73
<tr><td><b>Page map</b><td><td>no
<tr><td><b>Buffer fetch</b><td><td>no
<tr><td><b>Relax cursor stability</b><td><td>no</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Index</font></b>
<tr><td><b>Index name</b><td><td>FS_Item_Type
<tr><td><b>Key type</b><td><td>primary key
<tr><td><b>Clustered index</b><td><td>no
<tr><td><b>Depth</b><td><td>1
<tr><td><b>Estimated leaf pages</b><td><td>1</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font
size=+1>Scan</font></b>
<tr><td><b>Selectivity</b><td><td>0.54730% Column-Column
<tr><td><b>Direction</b><td><td>forward
<tr><td>CODE = FS_Item.TYPE ASC</table></p><p><table cellspacing=0
cellpadding=0 color="#000000"><tr><td><b><font size=+1>Node
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.95777<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0.10214<td><td>Run time as a percent
of total query time
<tr><td><b>RunTime</b><td><td>7.3944e-006<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>7.3944e-006<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p><p><table
cellspacing=0 cellpadding=0 color="#000000"><tr><td><b><font size=+1>Subtree
Statistics</font></b>
<tr><th ALIGN=left><td> <th ALIGN=left>Estimates<td> <th
ALIGN=left>Description<td>
<tr><td><b>RowsReturned</b><td><td>0.95777<td><td>Number of rows returned
<tr><td><b>PercentTotalCost</b><td><td>0.10214<td><td>Run time as a percent
of total query time
<tr><td><b>RunTime</b><td><td>7.3944e-006<td><td>Time to compute the results
<tr><td><b>CPUTime</b><td><td>7.3944e-006<td><td>Time required by CPU
<tr><td><b>DiskReadTime</b><td><td>0<td><td>Time to perform reads from disk
<tr><td><b>DiskWriteTime</b><td><td>0<td><td>Time to perform writes to disk
<tr><td><b>DiskRead</b><td><td>0<td><td>Disk reads
<tr><td><b>DiskWrite</b><td><td>0<td><td>Disk writes</table></p></font>]]>
</details>
</operator>
</operator>
</operator>
</operator>
</operator>
</query>
<joinenumeration>
<![CDATA[<enum>
<subplannode><!-- id: 1003 -->
<pn><id>1</id><corr>FS_Item_Type</corr><jm>16</jm><idx>FS_Item_Type</idx><!-
- join methods: --><!-- indexes: FS_Item_Type seq --></pn>
</subplannode>
<subplannode><!-- id: 1004 -->
<pn><id>2</id><corr>FS_Time_Type</corr><jm>16</jm><idx>FS_Time_Type</idx><!-
- join methods: --><!-- indexes: FS_Time_Type seq --></pn>
</subplannode>
<subplannode><!-- id: 0x03b03af8 -->
<pn><id>0</id><corr>FS_Item</corr><jm>16</jm><idx>FS_Item</idx><!-- join
methods: 1 --><!-- indexes: FS_Item seq --></pn>
<pn><id>1004</id><jm>9</jm><!-- join methods: 9 --><!-- indexes: --></pn>
<pn><id>1003</id><jm>9</jm><!-- join methods: 9 --><!-- indexes: --></pn>
</subplannode>
<!-- JOIN METHODS:
JOIN_NESTED_ITERATIO
N = 1
JOIN_BLOCK_NESTED = 2
JOIN_SORT_MERGE = 3
JOIN_HASH = 4
JOIN_NONPIPELINED_SE
MIJOIN = 5
JOIN_PIPELINED_SEMIJ
OIN = 6
JOIN_NONPIPELINED_SE
MIJOIN = 7
JOIN_PIPELINED_SEMIJ
OIN = 8
JOIN_NESTED_ITERATIO
N_OUTER = 9
JOIN_BLOCK_NESTED_OU
TER = 10
JOIN_SORT_MERGE_OUTE
R = 11
JOIN_HASH_OUTER = 12
JOIN_HASH_RECURSIVE_
OUTER = 13
JOIN_NESTED_ITERATIO
N_FULL_OUTER = 14
JOIN_SORT_MERGE_FULL
_OUTER = 15
JOIN_NOJOIN = 16
JOIN_DFP = 17
JOIN_UNKNOWN = 18
JOIN_SORT_MERGE_INTE
RSECT = 19
JOIN_HASH_INTERSECT = 20
JOIN_HASH_EXCEPT = 21
JOIN_SORT_MERGE_EXCE
PT = 22
JOIN_HASH_RECURSIVE = 23
JOIN_COLLAPSED = 24
-->
</enum>
]]>
</joinenumeration>
</asaPlan>
"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96376A168366
Cfishburnsybasecom@1
27.0.0.1...
> "Lucas Deby" <Lucas_Deby@ApexSI.com> wrote in
> news:425d1ad0$1@foru
ms-1-dub of sybase.public.sqlanywhere.ultralite:
>
> When you run this query in DBISQL, have you looked at the ULPlan to see
> what plan it will use?
>
> Also, you can run ulgen -l short|long|xml which will show the plan UL
> will use for each of the statements.
>
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD number with
> EACH post (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
> [url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
>
|
|
|
|
|