Sort Key - How to check whether segment getting eliminated or not

Help Query Tuning
1

Hi All,

Can someone pls suggest how I can check the number of segment being scanned and how many segments are getting eliminated when using a sort key column in the where clause to filer the data?

I checked Explain plan but it doesn’t say how many segments getting eliminated.

Thanks
Himanshu

2

Use SHOW PROFILE JSON, then look for segments_skipped. See

and search for segments_skipped. Also, in graphical profile in the managed service portal or Studio, if you click on a scan operator, its properties show on the right. You may be able to find it in there too. That graphical view layers on top of the json profile.

3

Thanks @hanson. I actually found it out.

There was a context behind asking this question. I will post another question with detailed scenario.