The invention relates to the technical field of
data optimization, and discloses a financial
data warehouse intelligent
SQL (Structured
Query Language) optimization method based on a
large model, which comprises the following steps: S1,
SQL statement analysis and preprocessing: carrying out word segmentation, grammatical analysis and
logic structure analysis on an
SQL statement submitted by a user, and identifying keywords, table structures and query conditions in query; s2,
large model semantic understanding and optimization suggestion: performing semantic understanding and
logical reasoning on the analyzed SQL statements by using a
large model, and automatically generating optimization suggestions, the optimization suggestions including index recommendation,
query rewriting and
execution plan optimization; and S3, generating and selecting a dynamic
execution plan. According to the method, the advantages of a large model in the aspects of
natural language processing and
intelligent decision making are fully utilized and combined with the specific requirements of the financial
data warehouse, and the execution efficiency of SQL query and the overall performance of the
system are remarkably improved; the query
response time of the financial
data warehouse can be effectively shortened, and the
resource utilization rate is improved.