Configuring Query Indexes
Indexes are used in query for efficiency.Indexes are based on the type of a class. The user may further specify the attributes of the class on which indexes are required. Query Indexes can be configured as follows:
Using NCache Manager
Using Command Line Tool
-
Open command prompt
-
Go to the NCache tools directory: cd %NCHOME%/bin/tools
-
Use addqueryindex.exe, provide the required information:
addqueryindex.exe demoLocalCache /a C:\temp\Data.dll /c NCache.Sample.Data.Product /L ProductID$ProductName$Category$Supplier$UnitsAvailable
addqueryindex.exe demoLocalCache /a C:\temp\Data.dll /c NCache.Sample.Data.Customer /L CustomerID$CompanyName
-
Hit ENTER key, it will add ProductID, ProductName, Category, Supplier and UnitsAvailable attributes from the class NCache.Sample.Data.Product and NCache.Sample.Data.Customer of Data.dll in query indexes for demoLocalCache.
See Also