You have altered an index supporting a constraint to be invisible on a large read only data warehouse table, to determine it Smart Scan operations will be fast...