Is your table partitioned ? Sent from my iPad
On Sep 30, 2013, at 2:09 AM, Yang <teddyyyy...@gmail.com> wrote: > 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
