This narrative review synthesizes evidence on how varying levels of alcohol consumption influence cognitive health. It identifies a U- or J-shaped relationship: light to moderate alcohol use is associated with preserved cognitive performance and reduced dementia risk, possibly due to cardiovascular benefits and reduced inflammation. In contrast, heavy drinking increases