Gossamer Forum
Home : Products : DBMan SQL : Discussion :

indexing schemes

Quote Reply
indexing schemes
What do the different indexing schemes mean?

I'm unable to use MySQL indexing since the version of MySQL on the server I'm using is only 3.22.27 and it apparently needs to be 3.23.23 or better.

"Internal" indexing appears to create two new tables called [table]_Score_List and [table]_Word_List.

Is it fair to assume this is a way of improving search speed and results relevance? What are the pros/cons of one scheme over another? Should I be pressing the company whose server this is to upgrade to a newer version of MySQL?

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
Subject Author Views Date
Thread indexing schemes hennagaijin 2935 Oct 7, 2002, 1:53 PM
Post Re: [hennagaijin] indexing schemes
jaspercram 2787 Oct 14, 2002, 3:11 AM