Archives of the TeradataForum
Message Posted: Mon, 20 Mar 2006 @ 22:22:13 GMT
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 ???
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|