|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2010年04 期
| 標(biāo)題 |
| Sybase臨時表技術(shù)的多層級應(yīng)用研究(19 卷) |
| 英文標(biāo)題 |
| Study on multi levels application of Sybase temporary table technology |
| 摘要 |
| Sybase臨時表用于存儲過程或批命令中多個SQL語句間傳遞數(shù)據(jù)，可分解事務(wù)處理流程，減輕并發(fā)壓力，改善查詢性能。應(yīng)用臨時表，首先提倡多用，使編程思路清晰，優(yōu)化處理性能；其次要巧用，大幅度提高存儲過程執(zhí)行速度；第3要注意臨時表對存儲過程預(yù)編譯執(zhí)行計劃的影響，采用強(qiáng) |
| 作者 |
| 新聞作者:王奇成 |
| 關(guān)鍵字 |
