(Hemant K Chitale) Oracle tracks the usage of columns as query predicates to determine candidate columns for the creation of histograms. In earlier versions, we would query SYS.COL_USAGE$ to identify such columns.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help