 |
 |
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 ?
Joseph D'silva
| |
