PostgreSQL'de başarım

• EXPLAIN

• Örnek:

• tdmsoft=# EXPLAIN ANALYZE SELECT firm_info.full_name, cases.id, userdetails.name,userdetails.surname,cases.case_def FROM cases LEFT OUTER JOIN firm_info ON (firm_info.id=cases.firm_id) LEFT OUTER JOIN userdetails ON (user_id=userdetails.id) WHERE cases.case_closed='f' AND cases.active='t' AND cases.id='2';

Notes: