SQcript优化指南：提升数据密集型逻辑可读性与结构化处理.pdfVIP

CREATETYPEASTABLEtt_publishers...

CREATETYPEASTABLEtt_years...

CREATEPROCEDUREgetOutput(INcntINTEGER,

INcurrencyVARCHAR(3),

OUToutput_pubstt_publishers,

OUToutput_yeartt_years)

LANGUAGESQLSCRIPTREADSSQLDATAAS

BEGIN

big_pub_ids=SELECTpublisherFROMbooks--QueryQ1

GROUPBYpublisherHAVINGCOUNT(isbn):cnt;

big_pub_books=SELECTtitle,price--QueryQ2

FROM:big_pub_ids,publishers,booksSqlScript

WHEREpub_id=pidANDpub_id=publisher

ANDcrcy=:currency;Compiler

output_pubs=SELECTSUM(price)--QueryQ3

FROM:big_pub_booksGROUPBYpublisher;

output_year=SELECTSUM(price)--QueryQ4

FROM:big_pub_booksGROUPBYyear;

END;

SqlScriptV1StoredProcedure

SingleAssignmentMultipleAssignment

DataFlow,NoLoopsControlFlow,Loops,If,State

CompiledintoCalcModelsCompiledintoC

ExecutedinRuntimesofNewDBNativecodeonLinux