Abstract The Chang 8 reservoir of the Huanjiang Oilfield in the Ordos Basin is a tight sandstone reservoir with poor reservoir physical properties and uneven oil distribution. In this study, the effective reservoirs developed on a large scale under the condition of horizontal well volume fracturing technology of the Chang 8 Member was identified based on the data of core observation, experimental analysis, logging, oil test, and production dynamics, and the identification standard of effective reservoirs in terms of reservoir physical properties, oil content, and comprehensive logging characteristics of gas logging was established. This scheme allows for a thorough identification of the effective reservoirs for horizontal well development in tight sandstone reservoirs. The findings indicate that the study area’s tight oil resources can be successfully produced. The well logging results show that the oil-bearing property of sand bodies with oil stains is better than that of oil spots. The bottom limit of the acoustic wave time difference is 210 μs/m, the permeability is 0.03 mD, the porosity is 6.0%, the rock resistivity is 30 Ω m, and the total hydrocarbon gas measurement value exceeds five times the baseline. At the same time, the total oil thickness is greater than 6 m, and the thickness of a single sand body is above 4 m. We have defined the lower limit standard of high-efficiency reservoir of Chang 8 tight oil in L289 block of Huanjiang oilfield. According to the analysis of oil-bearing property, comprehensive logging display, and reservoir thickness, the geological “sweet spots” is optimized to provide reference for subsequent mining. Through comparative analysis, the rules and trends are found to provide a basis for selecting mining strategies. With the help of technical means such as numerical simulation and geological modeling, the prediction accuracy and decision-making effect are improved. By clarifying the lower limit standard of reservoir, optimizing geological “sweet spots” and avoiding risk areas, the mining efficiency is improved and the cost is reduced, which provides reference for similar oilfield development.