Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 6 of 6 total

Sat, Nov 25 2023 5:08 AM	Permanent Link
Ian Branch	Hi Team, Should I be able to create a Text Index on a CLOB field in a View and then open the View? If not, why not? Regards & TIA, Ian
Sat, Nov 25 2023 4:26 PM	Permanent Link
Raul Team Elevate	<<Hi Team, Should I be able to create a Text Index on a CLOB field in a View and then open the View? If not, why not? Regards & TIA, Ian >> Unless I'm misunderstanding what you're asking it's a no. View is a virtual construct - basically a select statement. At most you can modify data underneath (if sensitive) but not metadata of the base tables. Raul
Sat, Nov 25 2023 4:47 PM	Permanent Link
Ian Branch	Hi Raul, I was afraid of that. The base tables do have Text Indexes but it doesn't help. Regards, Ian
Sun, Nov 26 2023 3:01 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian If you want the text index for speed I can't help. If its to select then my TextSearch function (yoou have a copy) may do the job Roy Lambert
Sun, Nov 26 2023 3:17 AM	Permanent Link
Ian Branch	Hi Roy, It's for speed, given the general performance/age of the Customer's Server PC. Ian
Sun, Nov 26 2023 7:28 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian EMail me an example of what you're trying to do. Roy Lambert