• Facebook
  • Twitter
  • Youtube
  • LinkedIn
  • RSS
  • Docs
  • Comparisons
  • Blogs
  • Try NCache
  • Contact Us
Try NCache
Show / Hide Table of Contents

Remove-QueryIndex

This PowerShell cmdlet enables users to remove pre-defined query indexes from cached object classes or selected attributes. It is used to remove unused or obsolete indexes in order to optimize memory consumption, reduce write-time overhead, and improve overall cache performance. Removing query indexes does not affect the cached data itself but disables indexed SQL-like querying for the specified classes or attributes.

Remove-QueryIndex -CacheName [-AttributesList] `
                  -Class [-Port] `
                  [-TlsCertPath] [-TlsCertPassword] `
                  [-Server] [-Credentials] `
                  [-NoLogo]

Examples

  • This command removes query indexes for the class Customer.
Remove-QueryIndex -CacheName defaultCache -Class Data.Customer
  • This command removes query indexes for the Customer class on server 20.200.20.11.
Remove-QueryIndex -CacheName defaultCache -Class Data.Customer `
                  -AttributesList "CustomerID'$'FirstName" -Server 20.200.20.11
  • This command removes the query indexes for Data.Customer from defaultCache on the specified server with mutual TLS (mTLS) enabled. It runs from a machine where NCache is not installed and uses C:\certs\client.pem to authenticate the machine running the cmdlet. The -TlsCertPassword parameter decrypts the certificate’s password-protected private key. Omit this parameter if the private key is not encrypted.
Remove-QueryIndex -CacheName defaultCache -Class Data.Customer `
                  -Server 20.200.20.11 -TlsCertPath "C:\certs\client.pem" `
                  -TlsCertPassword "clientKeyPassword"
  • This command removes query indexes for the class Customer using security credentials.
Remove-QueryIndex -CacheName defaultCache -Class Data.Customer `
                  -Credentials (Get-Credential john_smith)

Properties

Note

The parameters with asterisk (*) on their names are the required parameters and the rest are optional.

Parameters Data Types Description Default Value
-CacheName* <String> Specifies the name of the cache for which query indexing needs to be removed.
NOTE: The cache must already exist on the source server.
-
-AttributesList <String> Specifies the attributes for removing query indexing. If multiple attributes are needed, they are separated by a ‘$’. -
-Class* <String> Specifies the name of the class for which query indexing needs to be removed. -
-NoLogo <SwitchParameter> Suppresses display of the logo banner. False
-Port <Integer> Specifies the server port where the NCache Service is listening. 9803
-Server <String> Specifies a server name where the NCache Service is running and a cache with the specified cache-name is registered. IP of local machine
-TlsCertPath <string> Path to the client PEM certificate used to authenticate the machine running the NCache PowerShell cmdlet when connecting to an NCache server with mutual TLS (mTLS) enabled. The PEM file must contain the private key, leaf certificate, and any intermediate certificates. You can generate a certificate using New-NCacheTlsCertificate. This parameter is required when running the PowerShell module from a machine where NCache is not installed and the server requires mTLS. On a machine with an NCache server installation, the node's own certificate is used automatically. Relative paths are resolved against the current PowerShell location, and the file must exist. To configure the certificate presented by the server, use -CustomCertificatePath. -
-TlsCertPassword <string> Password used to load the encrypted private key in the PEM file specified by -TlsCertPath. Required only when the private key is password-protected. Not needed for an unencrypted private key. The password is used only to load the client certificate for the current command's connections. It is not saved in the NCache server configuration. -
-Credentials <pscredential> Specifies the user credentials required to authorize access for the specified operation. These credentials should belong to a user with the appropriate permissions at the node. -

Contact Us

PHONE

+1 214-619-2601   (US)

+44 20 7993 8327   (UK)

 
EMAIL

sales@alachisoft.com

support@alachisoft.com

NCache
  • Edition Comparison
  • NCache Architecture
  • Benchmarks
Try NCache
Pricing
NCache Playground

Deployments
  • Cloud
  • Docker
  • Kubernetes
  • On-Premises
Technical Use Cases
  • ASP.NET Sessions
  • ASP.NET Core Sessions
  • Pub/Sub Messaging
  • SignalR Backplane
  • Internet of Things (IoT)
  • NoSQL Database
  • Stream Processing
  • Microservices
Resources
  • Blogs
  • Foundations
  • Videos
  • Comparisons
  • Shows
  • Whitepapers
  • Articles
  • Tech Talks
  • Magazine Articles
  • Third-Party Articles
Customer Case Studies
  • Testimonials
  • Customers
Support
  • Docs
  • Schedule a Demo
  • Tips
Company
  • Leadership
  • Partners
  • News
  • Events
  • Careers
Contact Us

  • EnglishChinese (Simplified)FrenchGermanItalianJapaneseKoreanPortugueseSpanish

  • Terms of Use
  •  
  • Privacy Policy
  •  
  • Cookie Policy
© Copyright Alachisoft 2002 - . All rights reserved. NCache is a registered trademark of Diyatech Corp.
  • Facebook
  • Twitter
  • Youtube
  • LinkedIn
  • RSS