Thanks a lot for the reply, is it independent of merge factor?? My index size reduced a lot (almost by 40%) after optimization and i am worried that i might have lost the data. I have no deletes at all but a high merge factor. Any suggestions?
Thanks, Karthik
