Well you sure need a representative dataset to optimize your queries. Often, that means a replica of the production server, with real PII data in there.

I usually try to use mocked data as far as possible, but I guess the last validating step usually involves real data. Perhaps this can be used to optimize up to a certain point and then you can validate against production data as a last step.