---
title: "Indira Unnikrishnan (@IndiraD) | Hashnode"
description: "Indira Unnikrishnan (@IndiraD) writes on Hashnode. Read their latest articles and follow their work."
url: "https://hashnode.com/@IndiraD"
---

@IndiraD

# Indira Unnikrishnan

@IndiraD · Joined July 2025

### [SQL Optimization](https://learnandlead.hashnode.dev/sql-optimization?utm_source=hashnode&utm_medium=feed)

SQL is the language that helps us talk to databases, and like any language, it's more effective when used wisely. Imagine you're looking for a book in a giant library. Would you walk down every aisle, or would you use a catalog to go straight to it? ...

7 min read · [learnandlead.hashnode.dev](https://learnandlead.hashnode.dev/sql-optimization?utm_source=hashnode&utm_medium=feed)

[Aug 26, 2025](https://hashnode.com/posts/sql-optimization/68adef789c7ac4ad12da352f)

### [Mastering SQL Server Window Functions – Concepts](https://learnandlead.hashnode.dev/mastering-sql-server-window-functions-concepts?utm_source=hashnode&utm_medium=feed)

SQL Server window functions are essential for analytics, reporting, and business intelligence. They allow you to perform calculations across sets of rows while retaining row-level detail. In this article, we’ll explore the most important window funct...

4 min read · [learnandlead.hashnode.dev](https://learnandlead.hashnode.dev/mastering-sql-server-window-functions-concepts?utm_source=hashnode&utm_medium=feed)

[Aug 25, 2025](https://hashnode.com/posts/mastering-sql-server-window-functions-concepts/68ac7d4bd574dabd2975b1df)

### [Common Table Expressions (CTEs) in SQL](https://learnandlead.hashnode.dev/common-table-expressions-ctes-in-sql?utm_source=hashnode&utm_medium=feed)

Learn how to use Common Table Expressions (CTEs) in SQL Server with real examples, recursive queries, ASCII flowcharts, and key pros and cons explained.

8 min read · [learnandlead.hashnode.dev](https://learnandlead.hashnode.dev/common-table-expressions-ctes-in-sql?utm_source=hashnode&utm_medium=feed)

[Jul 23, 2025](https://hashnode.com/posts/common-table-expressions-ctes-in-sql/68813d6f675d70c624283489)
