I am using 8.0.3 One problem I found is that even if I specify to create a clustered index by "cluster idx_name on table_name", I still can not tell the optimizer that the index of "idx_name" is a clustered index with "index correlation" value as 1.0 (traced from the cost_index() in costsize.c) so where is the "index correlation" information stored and how can i update it? thanks Huaxin