Tagged: SQL

[ORACLE] – Amélioration de la performance de la base maximo oracle 0

[ORACLE] – Improved database performance oracle maximo

Default, Oracle uses the cost-based optimizer to determine the best execution plan for a query. To enable the optimizer to better estimate costs, you can calculate statistics...

[SQL] – Requete pour trouver les doublons 0

[SQL] – Query to find duplicates

Example : select count(*) as DUPLICATE ,AssetId , ASSETID from ASSET T1 where ASSETID in( SELECT ASSETID FROM ASSET T2 where T1.ASSETNUM=T2.ASSETNUM GROUP BY ASSETID , ASSETNUM HAVING COUNT(*) > 1 ) group by...