Where is the autotrace tool

Get Our Newsletter. June 8, by James Carlin. Should you upgrade to SQL R2? April 26, Support Hour Webcast Topics for November 19, If you want to trace the longer path, press the Ctrl key to override default AutoTrace direction. When you are autotracing a closed polyline, the trace line never crosses the start and end points of the polyline so the Ctrl key has no effect.

Environment Details. Products affected: MapInfo Professional. All versions of MapInfo. Article Record Type. Total number of data blocks read from disk. This number equals the value of "physical reads direct" plus all reads into buffer cache. Number of sort operations that were performed completely in memory and did not require any disk writes. Your output may vary depending on the version of the server to which you are connected and the configuration of the server. This option is useful when you are tuning a large query, but do not want to see the query report.

When you trace a statement in a parallel or distributed query, the execution plan shows the cost based optimizer estimates of the number of rows the cardinality. In general, the cost, cardinality and bytes at each node represent cumulative results.

For example, the cost of a join node accounts for not only the cost of completing the join operations, but also the entire costs of accessing the relations in that join.

Each operation is explained in the second part of the report. The second section of this report consists of three columns displayed in the following order:. Shows the text of the query for the Oracle Real Application Clusters database or remote database.

Line 0 of the Execution Plan shows the cost based optimizer estimates the number of rows at 1, taking 26 bytes. The total cost of the statement is 1. Lines 2, 3, 4 and 5 are marked with asterisks, denoting parallel operations.

Line 2 also shows that the parallel query server had the identifier Q Numbers identifying parallel report lines cross reference the line of the parent report. For example, in the last line of the example:. Improve this question. Ben Ben 2 2 gold badges 9 9 silver badges 18 18 bronze badges. Add a comment. Active Oldest Votes. The tracing tool has moved to the Snapping toolbar :. Improve this answer. Joseph Joseph Sorry to butt in Kazuhito - Don't apologise :.