• No replies
2 Posts

Pinned topic Using Custom document class name for document search

‏2013-04-17T00:41:40Z |

Hi All,

is there any performance improvement if we write search query using  exact document class name rather than using OOTB doc class name "Document" in FileNet P8 search?

In the below two queries which one will be faster/performance considering the fact every doc class will have one table in FileNet P8 database?



SELECT TOP N * from DOCUMENT where DocumentTitle="abc"------------>using OOTB document class "DOCUMENT"


SELECT TOP N * from MYDOCUMENTCLASS where DocumentTitle="abc"------------>using custom document class "MYDOCUMENTCLASS"