Re: distinct clause issue for 600000 records

[Ra Nala]

Thank you very much, below are my updates for your queries.

@ Øystein Grøvlen : 1. LEFT JOIN: Don't use it if you do not mean it.

Ra Nala : I should use Left join only why because i want each and every records from left table i.e main table: prdsl even though null records retrieve if the join condition is not matched from right table in my scenario.

@ Øystein Grøvlen : 2. ON clause is for join conditions

Ra Nala : yes i want records for "ea2.address_type='Bil' and for other records will get null values if not matched. If i placed this condition in where clause i will get limited records, i want total records from i.e main table: prdsl

@ Øystein Grøvlen :3. Do not include tables that are not used in query.

Ra Nala : Yes Sir, you are 100% correct. I am using tables beship, beinv, and reginv in my joins but not retrieving any columns from these. i need to modify query. actually, previously we used few columns from these tables and few days back we removed columns but we forgot to remove tables in Joins.

Thank you very much for your valuable inputs.