huaxin zhang <uwcssa@xxxxxxxxx> writes: > 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) The next ANALYZE should figure that out. regards, tom lane