9171 loops=1)
               Foreign File: /etc/dictionaries-common/words
               Foreign File Size: 938848
 Total runtime: 218.966 ms</PRE
><P>

    Using the materialized view:

</P><PRE
CLASS="PROGRAMLISTING"
> Limit  (cost=0.28..1.02 rows=10 width=9) (actual time=24.916..25.079 rows=10 loops=1)
   -&#62;  Index Scan using wrd_trgm on wrd  (cost=0.28..7383.70 rows=99171 width=9) (actual time=24.914..25.076 rows=10 loops=1)
         Order By: (word &#60;-&#62; 'caterpiler'::text)
 Total runtime: 25