In the below query both table has less than 1 million data. Can u tell me the reason of this plan? why its takin extensive cost , seq scan and sorting?? wat is Materialize?
select 1 from service_detail left join non_service_detail on non_service_detail_service_id = service_detail.service_detail_id