Welcome to the Oracle community forum and interact with 2 million technical staff. output result: COUNT star 20 times: 0.14COUNT each column 20 times: 0.14COUNT is used for 20 times for each column: 0.15COUNT is used for 20 times for each column: 0.16COUNT is used for 20 times for each column: 0.15COUNT is used for 20 times for each column: 0.15C
Welcome to the Oracle community forum, and interact with 2 million technical staff> output result: COUNT star 20 times: 0.14 COUNT each column 20 times: 0.14 COUNT the time for each column is 20 times: 0.15 COUNT the time for each column is 20 times: 0.16 COUNT the time for each column is 20 times: 0.15 COUNT the time for each column is 20 times: 0.15 C
Welcome to the Oracle community forum and interact with 2 million technical staff> enter
Output result:
The time for COUNT star 20 times is: 0.14
The COUNT time for each column is 20: 0.14
The COUNT time for each column is 20: 0.15
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.15
The COUNT time for each column is 20: 0.15
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.15
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.16
The COUNT time for each column is 20: 0.17
The COUNT time for each column is 20: 0.17
The COUNT time for each column is 20: 0.17
The COUNT time for each column is 20: 0.17
The COUNT time for each column is 20: 0.17
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.17
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.17
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.17
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.18
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.19
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.20
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.21
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.22
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.23
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.24
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.25
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.26
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.27
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.28
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.34
The COUNT time for each column is 20: 0.33
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.29
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.30
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
The COUNT time for each column is 20: 0.31
The COUNT time for each column is 20: 0.32
It can be seen that the longer it takes for the column to be followed, but it is the same as count (1) and count (*), because 1 is data not a column and does not need to be located.
[1] [2]