[求助]索引和程序

blanc

不清..不明..

有2個問題請教各位前輩

1, 建索引從物理和邏輯上到底是個什么樣的過程???

2,何為BIND PACKAGE???那什么時候又需要REBIND PACKAGE呢??

還望賜教~

blanc

謝謝樓上的

對于第一個問題.我得意思是,

對于建立索引到底是個什么樣的概念,DB2是如何通過索引訪問

重建索引的時間和效率和記錄的物理空間排列,記錄的順序是否有關(guān)


謝謝

lklgdkp

If reorganization is recommended, use the REORG utility on the selected objects and then do RUNSTATS and REBIND. You must perform a REBIND on any packages affected by the above operations, so they can take advantage of the benefits of the new physical organization and updated statistics. After performing subsequent update, insert, and delete operations, as part of the data maintenance process, repeat by first executing the RUNSTATS utility.

(DB2 UDB v8 for Linux, UNIX, and Windows Database Administration Certification Guide, 5th Edition上面的插圖和說明)

zzjijun

關(guān)系性數(shù)據(jù)庫的索引一般是B樹或是B+樹的結(jié)構(gòu)，樓主先去看看數(shù)據(jù)結(jié)構(gòu)中的相關(guān)內(nèi)容就會很清晰了。