Home / Questions / Tell me a table name where Full Text Indexes is present in D365 F&O
Explanatory Question

Tell me a table name where Full Text Indexes is present in D365 F&O

👁 0 Views
📘 Detailed Answer
🕒 Easy to Read
Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.

Answer with Explanation

Examples:

  • EcoResProduct
  • EcoResProductTranslation (for text search)
EcoResProduct Full Text Indexes
Figure: EcoResProduct Full Text Indexes

Full Text Indexes
Figure: Full Text Indexes

👉 Why?
Because these contain:

  • Long text
  • Descriptions
  • Notes

👉 In most standard D365 tables:

  • Full Text Indexes node exists
  • But very few tables actually use it

👉 Microsoft mainly relies on:

  • Normal Indexes
  • Search frameworks
  • Global Address Book logic

Where You WON'T Usually See It

👉 Tables like:

  • CustTable
  • VendTable
  • SalesTable

👉 Why?
Because:

  • They use exact match indexes
  • Not full-text search