📄 dynamiclikeoptimization.out
字号:
ID ----------asdf asdg aasdf %foobar foo%bar foo_bar MAX_CHAR ij> execute p2 using 'values ''%'' ';ID ----------asdf asdg aasdf %foobar foo%bar foo_bar MAX_CHAR ij> -- fail, no end blankd padexecute p1 using 'values ''%f'' ';ID ----------ij> execute p2 using 'values ''%f'' ';ID ----------asdf aasdf ij> execute p1 using 'values cast(''%f'' as varchar(2)) ';ID ----------ij> execute p2 using 'values cast(''%f'' as varchar(2)) ';ID ----------asdf aasdf ij> execute p1 using 'values ''%g'' ';ID ----------ij> execute p2 using 'values ''%g'' ';ID ----------asdg ij> execute p1 using 'values ''asd%'' ';ID ----------asdf asdg ij> execute p2 using 'values ''asd%'' ';ID ----------asdf asdg ij> execute p1 using 'values ''_%'' ';ID ----------asdf asdg aasdf %foobar foo%bar foo_bar MAX_CHAR ij> execute p2 using 'values ''_%'' ';ID ----------asdf asdg aasdf %foobar foo%bar foo_bar MAX_CHAR ij> execute p1 using 'values ''%_'' ';ID ----------asdf asdg aasdf %foobar foo%bar foo_bar MAX_CHAR ij> execute p2 using 'values ''%_'' ';ID ----------asdf asdg aasdf %foobar foo%bar foo_bar MAX_CHAR ij> -- one: aasdfexecute p1 using 'values ''_asdf'' ';ID ----------ij> -- fail: char blank padding significantexecute p1 using 'values ''_asdf %'' ';ID ----------aasdf ij> execute p2 using 'values ''_asdf'' ';ID ----------aasdf ij> execute p1 using 'values ''%asdf'' ';ID ----------ij> -- failexecute p2 using 'values ''%asdf'' ';ID ----------asdf aasdf ij> -- verify that like optimization being performedexecute p2 using 'values ''%'' ';ID ----------asdf asdg aasdf %foobar foo%bar foo_bar MAX_CHAR ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();1 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Statement Name: nullStatement Text: select id from test where vc10 like ?Parse Time: 0Bind Time: 0Optimize Time: 0Generate Time: 0Compile Time: 0Execute Time: 0Begin Compilation Timestamp : nullEnd Compilation Timestamp : nullBegin Execution Timestamp : nullEnd Execution Timestamp : nullStatement Execution Plan Text: Project-Restrict ResultSet (3):Number of opens = 1Rows seen = 7Rows filtered = 0restriction = falseprojection = true constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 restriction time (milliseconds) = 0 projection time (milliseconds) = 0Source result set: Project-Restrict ResultSet (2): Number of opens = 1 Rows seen = 7 Rows filtered = 0 restriction = true projection = false constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 restriction time (milliseconds) = 0 projection time (milliseconds) = 0 Source result set: Table Scan ResultSet for TEST at read committed isolation level using instantaneous share row locking chosen by the optimizer Number of opens = 1 Rows seen = 7 Rows filtered = 0 Fetch Size = 16 constructor time (milliseconds) = 0 open time (milliseconds) = 0 next time (milliseconds) = 0 close time (milliseconds) = 0 next time in milliseconds/row = 0 scan information: Bit set of columns fetched={0, 2} Number of columns fetched=2 Number of pages visited=1 Number of rows qualified=7 Number of rows visited=8 Scan type=heap start position: null stop position: ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -