What does byte field in explain plan signify
Hi,
Below is an example explain plan
############################################################################
SQL_ID 4x98k3xs3fbtz, child number 0
-------------------------------------
select user_name from fnd_user_cpy where user_id=20911870
Plan hash value: 850600944
----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 192 (100)| |
|* 1 | TABLE ACCESS FULL| FND_USER_CPY | 8 | 520 | 192 (3)| 00:00:03 |
----------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("USER_ID"=20911870)
Note
-----
- dynamic sampling used for this statement (level=2)
#######################################################################
I have few basic questions and I believe this forum is best way to get the most appropriate answers.
Above query would fetch one row. The column data type is varchar2(100)