Showing posts with the label SELECT Query OptimizationShow all
SQL Server
SQL Indexing Explained: Faster SELECT Queries With Practical Examples
Zaid Shaikh
September 24, 2025
Introduction In one of my project, we were facing slower responses from the microservice, though the benchmark target was within 10ms , due to larg…
Read moreMost Popular
Understanding Retryable Topics in Spring Boot Kafka
September 13, 2024
How to Modify Data in Spring Boot JPA Using Custom Queries
March 03, 2025
Tags
- @ControllerAdvice
- @ExceptionHandler
- @Mapper
- @Mapping
- @Modifying
- @NamedStoredProcedureQuery
- @Procedure
- @Query
- @RetryableTopic Annotation
- AI for Engineers
- AI Prompt Engineering
- Annotation Processing
- Annotation Processor
- Apache
- Apache Kafka
- API Automation
- API Development
- API Documentation
- Authentication
- Authorization
- AutoCloseable
- Automation
- Backend
- Backend Development
- Best Practices
- Build Profiles
- Cache Invalidation
- Cache Strategy
- caching
- camunda microservices saga
- camunda saga example
- camunda workflow orchestration
- camunda yaml configuration
- CLASS Retention
- Clean Architecture
- Clean Code
- Closeable
- Code Automation
- Code Efficiency
- Code Examples
- Code Generation
- Code Optimization
- Coding Standards
- Commit Messages
- Composite Types
- concurrency
- Configuration
- Custom Annotations
- Custom Code Generation
- Custom Exception
- Data Consistency
- Data Integrity
- Data Mapping
- Database Configuration
- Database Integration
- Database Performance
- Database Queries
- Database Tutorial
- Database Updates
- Declarative Web Service Client
- Dependency Management
- Derived Query Methods
- Developer Best Practices
- Developer Productivity
- Developer Tools
- DevOps Automation
- Distributed Systems
- Distributed Transactions
- Domain-Driven Design
- environment-specific configuration
- Error Handling
- Event Based Architecture
- Exception Handling
- Fault Tolerance
- Feign Client
- Feign Client Example
- FeignClient
- Filter
- Flexibility
- Git
- Git Best Practices
- Git Command Line
- Git Merge
- Git Tutorial
- Git Workflow
- Global Exception Handler
- Helm
- Hexagonal Architecture
- Hooks
- HTTP Calls
- I/O Operations
- Idempotency
- Idempotent Kafka Consumer
- Idempotent Producer
- Indexing
- Installation
- Integration
- IntelliJ
- Interceptor
- Java
- Java 5
- Java 7
- Java 8
- Java Annotations
- Java Best Practices
- Java controllers
- Java Development
- Java Frameworks
- Java Programming
- Java Serialization
- java spring boot
- JavaPoet
- JPA
- JPA Queries
- JPQL
- JWT
- Kafka
- Kafka Backoff Strategy
- Kafka Configuration
- Kafka Consumer
- Kafka Message Processing
- Kafka Producer
- Kafka Retry Configuration
- Kafka Retry Topics
- Kubernetes
- Linux
- Logrotate
- Machine Learning
- Map String Object
- Mapper Generation
- MapStruct
- Maven
- Message Processing
- Microservices
- Middleware
- Multi-Entity Caching
- Multiple DataSources
- MySQL
- NamedNativeQuery
- Native SQL
- Object Mapping
- OncePerRequestFilter
- OpenAPI 3
- OpenAPI Generator
- OpenAPI Specification
- Oracle
- Orchestrator Pattern
- POM
- Ports and Adapters
- PostgreSQL
- Producer Configuration
- Programming
- Programming Concepts
- Query
- Query Tuning
- Real-Time Applications
- redis
- Redis Best Practices
- Redis Caching
- Redis Design
- Redis Key Design
- Redis Key Patterns
- Redis Namespaces
- Redis Setup
- Redis Spring Boot
- Redis TTL
- REF CURSOR
- Reflection in Java
- Resilient Microservices
- Resource Management
- REST API
- RESTful API
- RetentionPolicy
- Retryable Topic
- RUNTIME Retention
- saga design pattern microservices
- Saga Pattern
- Scalability
- SELECT Query Optimization
- Service-to-Service Communication
- servlet container
- Servlet Filter
- Shell Script
- Software Architecture
- Software Design
- Software Development
- Software Engineering
- SOURCE Retention
- Spring
- Spring Annotations
- Spring Boot
- spring boot examples
- Spring Boot Kafka
- spring boot profiles
- Spring Boot Repository
- Spring Boot Transactions
- Spring Boot Tutorial
- Spring Cloud
- spring configuration
- Spring Data JPA
- Spring Framework
- Spring Kafka
- Spring MVC
- spring profiles
- Springfox
- SQL
- SQL Server
- Stored Procedure
- Stored Procedures
- Swagger 3
- Team Collaboration
- Tech Tutorials
- Testability
- thread safety
- TortoiseGit
- Transaction Management
- Try-With-Resources
- Tutorial
- Update Queries
- User Defined Type
- Utility
- Version Control