Archives of the TeradataForum
Message Posted: Wed, 13 Jun 2007 @ 10:59:12 GMT
| Subj: || || Re: 5728: Partitioning violation for table TARGET |
| From: || || D silva, Joseph Vinish |
| ||if the partition is on store_id|| |
| ||In the where clause if I give store_id = BANG001, The explain would show that partition is used.|| |
| ||but If i give like substr(store_id,5,7)=001, then it would do a all row scan.|| |
I doubt the optimizer can lookup the correct partition with the given info. Could you post the patitioning expression ?