Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
0 answers

Limiting SQL Full Text Indexing

I was wondering if there was a way to limit my Full Text Indexing to, in laymen terms, include a WHERE clause. CREATE FULLTEXT INDEX ON [Order] KEY INDEX [PK_Order] ON [ft_Order] WITH CHANGE_TRACKING AUTO ALTER FULLTEXT INDEX ON [Order] ADD…
JohnPete22
  • 523
  • 3
  • 15
0
votes
2 answers

Fastest way for Indexing Large Text File

I want to index large text file about 1 gb, so I store in another file new line positions, to access the file later by RandomAccessFile, here is my code while (true) { raf.seek(currentPos); byte[] bytes…
JustMe
  • 6,065
  • 3
  • 19
  • 17
0
votes
1 answer

Fulltext indexses prefixes

I have seen such construction: СREATE FULLTEXT INDEX product_all_idx ON product(description(5), name(3)); As i know 5 and 3 are prefixes of description and name. What is the main target of prefixes in fulltext index if we should search the word all…
NoActualName
  • 71
  • 9
0
votes
0 answers

How can i define a fixed html Type on fulltext index

I have a column content of type varbinary(max), which always contain html content. How can I define a fulltext index on that column of type .html without having to create another column ContentType and always store .html? For example, here I have to…
Ali Kleit
  • 3,069
  • 2
  • 23
  • 39
0
votes
0 answers

Big performance difference between using "|"(or), "&"(and) in PostgreSQL full text search

I created a table with about 100,000 data records in the database that includes "id"(serial4), "name"(text), "description"(text) and "vector"(tsvector) columns. The "vector" column is calculated and stored by the setweight of "name" and…
Hamiid
  • 9
  • 1
0
votes
0 answers

MySQL full text index doesn't show up in query plan when use with multiple match and related tables

explain select distinct o.id, o1.id, order_items.order_id from orders o left join orders o1 on MATCH(o1.po_number) AGAINST('+test*' IN BOOLEAN MODE) and o1.id=o.id left join order_items on…
Ajith Kumar
  • 1
  • 3
0
votes
1 answer

Ignore language in MongoDB text index

I am trying to create a text index in my MongoDB. The field I am trying to index is in the Czech language (cs), which is not supported (as it's not listed here). I would still like to index it, even if the stop words and other language specific…
P. Paul
  • 363
  • 3
  • 17
0
votes
1 answer

Cognitive search wild card search with special characters

We are using cognitive search for a search requirement, and i am unable to do a wildcard search on a field that has special characters. e.g., If the name field on a document has value - asdf, I am able to use search Text as* and am getting this…
Michael Scott
  • 540
  • 2
  • 8
0
votes
1 answer

MySQL Index Hints with Fulltext indexes

I`m having an issue with Fulltext indexes and trying to use index hints at the same time. This is a sample table: CREATE TABLE IF NOT EXISTS `products` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idcategory` bigint(20) NOT NULL, `name` text…
Alex Kuzmov
  • 3
  • 5
0
votes
0 answers

SQL Full text query too slow

I have some Full Text Catalogs and since some time ago, the query time really slow down, and the only solution I found until now is to rebuild the catalogs, sometimes more than once a day with command: ALTER FULLTEXT CATALOG TABLE1 REBUILD Why is…
Rui Oliveira
  • 11
  • 1
0
votes
0 answers

MySql FullText index taking more time to retrieve the result data

explain SELECT * FROM PersistentQueues.RequestQueue where MATCH (`data`) AGAINST ('{ "test": { "test": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 1001, 111, 201, 222, 3333, 888, 99, 88, 66, 324, 785, 952, 657, 458, 632, 746, 854, 421, 351, 364,…
Jose Lopez
  • 1
  • 3
0
votes
2 answers

Is there a way to use MySQL fulltext to search related tables?

I have a table called persons which contains data about, well, people. It also contains foreign keys to another table. I'd like to make a fulltext index that is able to search the related tables for full text. Here is some sample data: (see…
mankowitz
  • 1,864
  • 1
  • 14
  • 32
0
votes
2 answers

Mysql fulltext search didn't find exact phrase

I have a table with column name with fulltext index - In this table there is many rows but some of them contain the phrase "aberlour 18" exactly at start like here - But when I search using the fulltext search with exact name from the table …
dima_mak
  • 184
  • 1
  • 1
  • 10
0
votes
0 answers

Count number of rows using MATCH AGAINST on FullText index column

I have a table in my database that contains quite a lot of data. I have to run a query that should simply count the number of rows where a certain keyword is present in the Message column. Normally I would run this: SELECT count(1) FROM applogs…
Vivendi
  • 20,047
  • 25
  • 121
  • 196
0
votes
0 answers

It's possible FULLTEXT index MYSQL view columns

I want to search in multiple table, then i try to make a view with FULLTEXT index. every body can help? Response will be grate with an example ;)
marine727
  • 21
  • 7
1 2 3
…
37 38