Determining dynamic statistics based on key value patterns
A method for dynamically updating database statistics and a plurality of access paths associated with at least one database table is provided. The method may include identifying at least one dynamically changing column associated with the at least one database table. The method may further include determining at least one predicate pattern associated with the identified at least one dynamically changing column. Additionally, the method may include dynamically detecting at least one range change associated with the determined at least one predicate pattern based on at least one record insert. The method may also include updating the plurality of database statistics associated with the identified at least one dynamically changing column based on the dynamically detected at least one range change. The method may further include determining at least one filter factor based on the updated plurality of database statistics associated with the identified at least one dynamically changing column.
International Business Machines Corporation
G G G G G
G06F G06F G06F G06F G06F
inventional inventional inventional inventional inventional
Shuo Meng Chen Xin Shu Hua Xiao Di Xiaobo Xin Ying Wei Xiong Wei
Li Wan Yu Liu Deng Wang Yang Liu Zhao