we have a huge table, including browsing data for the past 5 years, let's say.
now I want to take a few samples to play around with it. so I did select * from mytable limit 10; but it actually went full out and tried to scan the entire table. is there a way to kind of create a "view" pointing to only one of the data files used by the original table mytable ? this way the total files to be scanned is much smaller. thanks! yang
