On Thu, Jan 19, 2012 at 05:36:26PM -0800, Jeff Amiel wrote:
> I COULD do an analyze after loading the file...but there is no guarantee that
> the file I just loaded will end up in the most common value listand I end
> up with bad plan.
>
Sounds like you need to SET STATISTICS higher for th
Ive got a scenario where I've got a 2 million row table. Data from inbound
files gets processed into it.
A new file might have 10 resulting rows in this table...might have
40K...depends on the source, day of month, etc.
I've got a process that parses the file and loads the records into the
t