Changed database context to 'otal_long_text_queries'. DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 1 ms. SQL Server Execution Times: CPU time = 0 ms, elapsed time = 1 ms. SQL Server parse and compile time: CPU time = 19875 ms, elapsed time = 19944 ms. c1 ----------- 1 (1 rows affected) Table 't1000'. Scan count 1, logical reads 3, physical reads 2, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions -------------------- -------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ------------------------------ ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------- -------------- -------------- ----------- ---------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ---------------------------------------------------------------- -------- ------------------ 1 1 select top 1 c1 from t1000 where c1 > 0 or (c5 = 1) or (c6 = 2) or (c7 = 3) or (c8 = 4) or (c4 = 5) or (c5 = 6) or (c6 = 7) or (c7 = 8) or (c8 = 9) or (c4 = 10) or (c5 = 11) or (c6 = 12) or (c7 = 13) or (c8 = 14) or (c4 = 15) or (c5 = 16) or (c6 = 17) or (c7 = 18) or (c8 = 19) or (c4 = 20) or (c5 = 21) or (c6 = 22) or (c7 = 23) or (c8 = 24) or (c4 = 25) or (c5 = 26) or (c6 = 27) or (c7 = 28) or (c8 = 29) or (c4 = 30) or (c5 = 31) or (c6 = 32) or (c7 = 33) or (c8 = 34) or (c4 = 35) or (c5 = 36) or (c6 = 37) or (c7 = 38) or (c8 = 39) or (c4 = 40) or (c5 = 41) or (c6 = 42) or (c7 = 43) or (c8 = 44) or (c4 = 45) or (c5 = 46) or (c6 = 47) or (c7 = 48) or (c8 = 49) or (c4 = 50) or (c5 = 51) or (c6 = 52) or (c7 = 53) or (c8 = 54) or (c4 = 55) or (c5 = 56) or (c6 = 57) or (c7 = 58) or (c8 = 59) or (c4 = 60) or (c5 = 61) or (c6 = 62) or (c7 = 63) or (c8 = 64) or (c4 = 65) or (c5 = 66) or (c6 = 67) or (c7 = 68) or (c8 = 69) or (c4 = 70) or (c5 = 71) or (c6 = 72) or (c7 = 73) or (c8 = 74) or (c4 = 75) or (c5 = 76) or (c6 = 77) or (c7 = 78) or (c8 = 79) or (c4 = 80) or (c5 = 81) or (c6 = 82) or (c7 = 83) or (c8 = 84) or (c4 = 85) or (c5 = 86) or (c6 = 87) or (c7 = 88) or (c8 = 89) or (c4 = 90) or (c5 = 91) or (c6 = 92) or (c7 = 93) or (c8 = 94) or (c4 = 95) or (c5 = 96) or (c6 = 97) or (c7 = 98) or (c8 = 99) or (c4 = 100) or (c5 = 101) or (c6 = 102) or (c7 = 103) or (c8 = 104) or (c4 = 105) or (c5 = 106) or (c6 = 107) or (c7 = 108) or (c8 = 109) or (c4 = 110) or (c5 = 111) or (c6 = 112) or (c7 = 113) or (c8 = 114) or (c4 = 115) or (c5 = 116) or (c6 = 117) or (c7 = 118) or (c8 = 119) or (c4 = 120) or (c5 = 121) or (c6 = 122) or (c7 = 123) or (c8 = 124) or (c4 = 125) or (c5 = 126) or (c6 = 127) or (c7 = 128) or (c8 = 129) or (c4 = 130) or (c5 = 131) or (c6 = 132) or (c7 = 133) or (c8 = 134) or (c4 = 135) or (c5 = 136) or (c6 = 137) or (c7 = 138) or (c8 = 139) or (c4 = 140) or (c5 = 141) or (c6 = 142) or (c7 = 143) or (c8 = 144) or (c4 = 145) or (c5 = 146) or (c6 = 147) or (c7 = 148) or (c8 = 149) or (c4 = 150) or (c5 = 151) or (c6 = 152) or (c7 = 153) or (c8 = 154) or (c4 = 155) or (c5 = 156) or (c6 = 157) or (c7 = 158) or (c8 = 159) or (c4 = 160) or (c5 = 161) or (c6 = 162) or (c7 = 163) or (c8 = 164) or (c4 = 165) or (c5 = 166) or (c6 = 167) or (c7 = 168) or (c8 = 169) or (c4 = 170) or (c5 = 171) or (c6 = 172) or (c7 = 173) or (c8 = 174) or (c4 = 175) or (c5 = 176) or (c6 = 177) or (c7 = 178) or (c8 = 179) or (c4 = 180) or (c5 = 181) or (c6 = 182) or (c7 = 183) or (c8 = 184) or (c4 = 185) or (c5 = 186) or (c6 = 187) or (c7 = 188) or (c8 = 189) or (c4 = 190) or (c5 = 191) or (c6 = 192) or (c7 = 193) or (c8 = 194) or (c4 = 195) or (c5 = 196) or (c6 = 197) or (c7 = 198) or (c8 = 199) or (c4 = 200) or (c5 = 201) or (c6 = 202) or (c7 = 203) or (c8 = 204) or (c4 = 205) or (c5 = 206) or (c6 = 207) or (c7 = 208) or (c8 = 209) or (c4 = 210) or (c5 = 211) or (c6 = 212) or (c7 = 213) or (c8 = 214) or (c4 = 215) or (c5 = 216) or (c6 = 217) or (c7 = 218) or (c8 = 219) or (c4 = 220) or (c5 = 221) or (c6 = 222) or (c7 = 223) or (c8 = 224) or (c4 = 225) or (c5 = 226) or (c6 = 227) or (c7 = 228) or (c8 = 229) or (c4 = 230) or (c5 = 231) or (c6 = 232) or (c7 = 233) or (c8 = 234) or (c4 = 235) or (c5 = 236) or (c6 = 237) or (c7 = 238) or (c8 = 239) or (c4 = 240) or (c5 = 241) or (c6 = 242) or (c7 = 243) or (c8 = 244) or (c4 = 245) or (c5 = 246) or (c6 = 247) or (c7 = 248) or (c8 = 249) or (c4 = 250) or (c5 = 251) or (c6 = 252) or (c7 = 253) or (c8 = 254) or (c4 = 255) or (c5 = 256) or (c6 = 257) or (c7 = 258) or (c8 = 259) or (c4 = 260) or (c5 = 261) or (c6 = 262) or (c7 = 263) or (c8 = 264) or (c4 = 265) or (c5 = 266) or (c6 = 267) or (c7 = 268) or (c8 = 269) or (c4 = 270) or (c5 = 271) or (c6 = 272) or (c7 = 273) or (c8 = 274) or (c4 = 275) or (c5 = 276) or (c6 = 277) or (c7 = 278) or (c8 = 279) or (c4 = 280) or (c5 = 281) or (c6 = 282) or (c7 = 283) or (c8 = 284) or (c4 = 285) or (c5 = 286) or (c6 = 287) or (c7 = 288) or (c8 = 289) or (c4 = 290) or (c5 1 1 0 NULL NULL NULL NULL 1 NULL NULL NULL 6.2837801E-3 NULL NULL SELECT 0 NULL 1 1 |--Top(TOP EXPRESSION:((1))) 1 2 1 Top Top TOP EXPRESSION:((1)) NULL 1 0 0.0000001 11 6.2837801E-3 [otal_long_text_queries].[dbo].[t1000].[c1] NULL PLAN_ROW 0 1 1 1 |--Filter(WHERE:([otal_long_text_queries].[dbo].[t1000].[c1]>(0) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(1) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(2) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(3) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(4) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(5) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(6) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(7) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(8) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(9) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(10) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(11) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(12) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(13) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(14) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(15) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(16) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(17) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(18) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(19) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(20) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(21) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(22) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(23) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(24) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(25) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(26) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(27) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(28) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(29) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(30) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(31) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(32) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(33) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(34) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(35) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(36) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(37) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(38) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(39) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(40) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(41) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(42) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(43) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(44) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(45) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(46) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(47) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(48) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(49) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(50) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(51) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(52) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(53) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(54) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(55) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(56) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(57) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(58) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(59) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(60) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(61) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(62) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(63) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(64) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(65) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(66) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(67) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(68) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(69) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(70) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(71) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(72) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(73) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(74) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(75) OR [otal_long_text_queries].[dbo]... 1 3 2 Filter Filter WHERE:([otal_long_text_queries].[dbo].[t1000].[c1]>(0) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(1) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(2) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(3) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(4) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(5) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(6) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(7) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(8) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(9) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(10) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(11) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(12) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(13) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(14) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(15) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(16) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(17) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(18) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(19) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(20) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(21) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(22) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(23) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(24) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(25) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(26) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(27) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(28) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(29) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(30) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(31) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(32) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(33) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(34) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(35) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(36) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(37) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(38) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(39) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(40) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(41) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(42) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(43) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(44) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(45) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(46) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(47) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(48) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(49) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(50) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(51) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(52) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(53) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(54) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(55) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(56) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(57) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(58) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(59) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(60) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(61) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(62) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(63) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(64) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(65) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(66) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(67) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(68) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(69) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(70) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(71) OR [otal_long_text_queries].[dbo].[t1000].[c6]=(72) OR [otal_long_text_queries].[dbo].[t1000].[c7]=(73) OR [otal_long_text_queries].[dbo].[t1000].[c8]=(74) OR [otal_long_text_queries].[dbo].[t1000].[c4]=(75) OR [otal_long_text_queries].[dbo].[t1000].[c5]=(76... NULL 1 0 600.11603 11 0.00628368 [otal_long_text_queries].[dbo].[t1000].[c1] NULL PLAN_ROW 0 1 1 1 |--Clustered Index Scan(OBJECT:([otal_long_text_queries].[dbo].[t1000].[t1000_pk])) 1 4 3 Clustered Index Scan Clustered Index Scan OBJECT:([otal_long_text_queries].[dbo].[t1000].[t1000_pk]) [otal_long_text_queries].[dbo].[t1000].[c1], [otal_long_text_queries].[dbo].[t1000].[c4], [otal_long_text_queries].[dbo].[t1000].[c5], [otal_long_text_queries].[dbo].[t1000].[c6], [otal_long_text_queries].[dbo].[t1000].[c7], [otal_long_text_queries].[dbo].[t1000].[c8] 1 21.166828 0.220157 31 0.0032831 [otal_long_text_queries].[dbo].[t1000].[c1], [otal_long_text_queries].[dbo].[t1000].[c4], [otal_long_text_queries].[dbo].[t1000].[c5], [otal_long_text_queries].[dbo].[t1000].[c6], [otal_long_text_queries].[dbo].[t1000].[c7], [otal_long_text_queries].[dbo].[t1000].[c8] NULL PLAN_ROW 0 1 (4 rows affected) SQL Server Execution Times: CPU time = 16 ms, elapsed time = 34 ms.