I have table
CREATE TABLE Customers (
CustNo NUMBER(10),
CustName VARCHAR2(30) NOT NULL,
City VARCHAR2(20) NOT NULL,
PRIMARY KEY (CustNo)
)
with data
insert into customers
select
rownum custno,
case mod(rownum,100)
when 0 then 'RAJA'
else object_name
end custname,
case round(dbms_random.value(1,5))
when 1 then 'CHENNAI'
when 2 then 'DELHI'
when 3 then 'BENGALURU'
when 4 then 'MUMBAI'
else 'KOLKATA'
end city
from all_objects
where rownum <= 10000;
I am checking explain for the query
explain plan for
select * from customers
where custname='RAJA'
and city='CHENNAI';
select * from table(dbms_xplan.display);
Explain plan
Plan hash value: 2008213504
---------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 17 | 714 | 32 (0)| 00:00:01 |
|* 1 | TABLE ACCESS STORAGE FULL| CUSTOMERS | 17 | 714 | 32 (0)| 00:00:01 |
---------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - storage("CUSTNAME"='RAJA' AND "CITY"='CHENNAI')
filter("CUSTNAME"='RAJA' AND "CITY"='CHENNAI')
Note
-----
- dynamic sampling used for this statement (level=2)
What is the option storage in predicate information means?