|
|
could you pls tell what your wildcard like? left- and double-truncated, or right-truncated?
for first one, you can use substring index, for later one, you can use prefix index.
regarding to cluster, partition and materilized view..., i am not sure if they are applicable for your case.
if you database is not data warehose, that means, updating frequently and no large data, it's recommended not to change table structure, but use index merely.
that's it! |
|
楼主: 影子3
IP卡
狗仔卡
发表于 2009-3-9 23:29
显身卡
