Re: partioning and wildcards
and this my output when I query:
explain partition select * ftom tbl_ngram where ngram_name like 'flew%' \G
****************************** 1.row ****************************
id:1
select type: SIMPLE
table: tbl_ngram
partitions: p0,p1,p2,p3, ...
type: index
possible_keys: NULL
key: PRIMARY
key_len: 261
ref: NULL
rows: 3672888
Extra: Using where; Using index
Ciao
Pascal
Subject
Views
Written By
Posted
4852
August 07, 2006 12:56AM
2351
August 21, 2006 10:46PM
2442
August 25, 2006 01:32AM
Re: partioning and wildcards
2536
August 25, 2006 01:40AM
2620
September 01, 2006 06:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.