When Oracle uses an index , it has various types of index scans available to retrieve the data . If we choose correct " index scan" based on various factors, like
where condition columns,
type of data ,
volume of query result the where condition filters ,
type of index etc
then, query will have good performance.
check out , 8 types of oracle index scans which can be used for sql tuning.
---------
[email protected] +91 991 2323 000
Link for Oracle Performance dba Tuning Training https://dbvidya.talentlms.com/catalog...
-
#OracleIndex #TableScan #Oracle12c
-
Oracle SQL Tuning Video Tutorial
https://dbvidya.talentlms.com/catalog...
Oracle DBA Performance Tuning
https://dbvidya.talentlms.com/catalog...
Oracle SQL Tuning Video Tutorial
https://dbvidya.talentlms.com/catalog...
ER Data Modeling Video Tutorial
https://dbvidya.talentlms.com/trainer...
Dimensional Modeling Video Tutorial
https://dbvidya.talentlms.com/catalog...
Erwin Tool Training Video Tutorial
https://dbvidya.talentlms.com/catalog...
Artist: Bensound
Song: Buddy
Website: http://www.bensound.com/
--------------------------------
"dbvidya" means - "database(db)+ Education(vidya)" -
we provide trainings pertaining to Database Designing,Data Modeling Tuning etc
-----------------------------
Would like to know your comments on the content of Video.
Do let us know , what you think about this video.
If you would like more information / any other topic , post your comment.
our team will try to post video of your interest.
Be part of our "dbvidya Database Group" by "Subscribing" our channel
------------------------------------------------
Facebook : / myonlineitcourses
website : www.dbvidya.com
Blog : http://www.dbvidya.com/blog/
e-Learning Courses list : https://dbvidya.talentlms.com/catalog...
Founder & Trainer : / batchumadhavi