Archives of the TeradataForum

Message Posted: Mon, 20 Mar 2006 @ 22:22:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I have a table xyz :

     CREATE SET TABLE xyz ,NO FALLBACK ,  NO BEFORE JOURNAL,  NO AFTER
     JOURNAL,   CHECKSUM = DEFAULT
          (c1 decimal(15,7)
           c2....
          ....
          ...
           c218)

So there are 218 columns in this table.

Total number of records are 190,000,000

The explain plan for

     select *
       from xyz
       where c1 between 35123456.0101021 and 12384940.0101012

show 4 mins and 07 secs

I have : c1 as the PI (unique) and c2, c3, c4, c5 are NUSI. Stats are colleted on all these indexed columns. Most of the columns are in compressed.

Is there any thing else I can do to tune this table/sql other then partition it ???

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>