Hi All, Need some urgent help.. I optimizing Stored Procedures. The current database is of 5 GB in size and a specific tables have more than a million records. And this is just the sample db. The original has more than 20 to 30 million records and expected to grow at the rate of 5 million record per week. Now i need to test the db for such huge data without replicating the information. I cant replicate the entire db. have to do with sample. Please help........ thanks!