Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > Index on custom table field View modes: 
User avatar
Member
Member
Scott - 1/30/2010 2:17:09 PM
   
Index on custom table field
I'd like to suggest a way to index field on custom tables from Site Manager.

In the meantime, will there be any issue if I go to SQL Server and manually add an index to the fields I need indexed? What will happen if I later make updates to the table in Site Manager? Will anything break? Will my index be preserved?

User avatar
Kentico Developer
Kentico Developer
kentico_martind - 2/9/2010 2:12:47 AM
   
RE:Index on custom table field
Hello,

Do you mean index for smart search? Regrettably, this is not currently supported and you would need to create custom search using Lucene.NET API and create custom index for custom table for it.

Best Regards,

Martin Dobsicek

User avatar
Member
Member
Scott - 2/9/2010 7:48:52 AM
   
RE:Index on custom table field
No, I mean a SQL Server index -- nothing to do with Smart Search. Thanks.

User avatar
Kentico Developer
Kentico Developer
kentico_martind - 2/15/2010 10:19:34 AM
   
RE:Index on custom table field
Hi Scott,

There shouldn't be any issue when adding index to fields in custom table. Please note that index won't be included in export/import functionality though.

Best Regards,

Martin Dobsicek

Top