I can use the cluster index on the table. But you can create only one cluster index in a table. In this table , lots of data need to search, so I choose the Lucene to do that.
On Jan 16, 2008 6:57 PM, <[EMAIL PROTECTED]> wrote: > > firstly, I submit the query like "select * from [tablename]". > > And in this > > table, there are around 30th columns and 40,000 rows data. > > And I use the > > standrandAnalyzer to generate the index. > > Why don't you use a database index? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Best Regards Cooper Geng