This paper carries on the discussion on database query optimization by building up index, optimizing index and optimizing access mode;