I have 30 millions document indexed and tried sort by "sequenceid" which is unique over the document. I am experiencing "very slow" than sort by pub_date. sequenceid is not defined as "unique key" in the schema.xml and there is the "unique key" defined in schema.xml - item_id.
Anyone knows why? Thanks, Jae
