Abstract This paper presents a comparative and experimental review of AI-assisted query optimization techniques in relational databases. The study examines traditional optimization methods, explores AI-based approaches including machine learning and reinforcement learning, and evaluates their effectiveness through experimental results. Keywords Query Optimization, Relational Databases, Artificial Intelligence, Machine Learning, Reinforcement Learning, Genetic Algorithms