If (Sel: Default - Undefined) is reported it may indicate that there was an error generating statistics, or that the operator has been disassociated from the statistical type, such as the st_envintersects operator. Once the statistics are captured using ArcCatalog, dbms_stats.gather_table_stats or dbms_stats.gather_index_stats the value for selectivity should then be reported. If (Sel: Default - No stats) is reported it indicates there are no statistics for the spatial index. Potentially one might see other for selectivity. If a high selectivity is derived, then its very possible the cost of using the index is greater then the cost of performing the full table scan.

The selectivity value is also input used by the optimizer to calculate the cost of using an index compared to performing a full table scan. Cardinality is simply calculated by multiplying the number of rows in the table by the selectivity -ġ78,321 parcels * (.162684/100) = 290 rows (rounded). The number of rows returned by the statement, 290 in above case, is the cardinality for the statement or predicate. The optimizer uses selectivity to represent the fraction of rows which are returned by the statement. 162684 represents the selectivity calculated by the st_domain_stats type based upon the input envelope from the st_envintersects operator. The following example demonstrates the output one would see using SQL*Plus and autotrace: This number is derived from the input envelope, the given operator and an execution plan chosen when the statement was parsed. The Sel: represents the selectivity the optimizer was provided by the st_domain_stats type. When reviewing an Oracle tkprof file or autotrace output from SQL*Plus, one might notice the string (Sel: ) after the operation DOMAIN INDEX. (New purchases of this tester come with 24 months free software) 12 months Software

Additional software, European, USA, Australian.Service light reset, warning light reset, Coding and adaptation.Live data display, digital, graphic, min & max & store.Self diagnosis, fault code read, store and clear.EMS, Airbag, ABS, Body control, Dashboard, Chassis, Comfort, Immobiliser, Diesel, etc.Menu vehicle selection, auto ECU scan, General search.Large range and depth of software Korea, Asian, European, USA & Australian.Pictorial & text diagnostic socket location.LCD backlight 320 x 240 resolution 40 columns x 12 lines.Compact hand held tester 256Mb built in memory.The Carman Scan Lite is a high quality, premium brand, hand held, Asian vehicle diagnostic scan tester with the addition of European, American and Australian software.

Carman scan 1 software cardinality