Reading Time: 1 minutesSQL Optimizer Hints - Quick tips and description on frequently used SQL Hints: SQL Optimizer Hints /*+ ALL_ROWS */: The ALL_ROWS hint explicitly chooses the cost-based approach to optimize a […]
Month: January 2017
SQL Tuning Tips
Reading Time: 2 minutesSQL Tuning Tips SQL Tuning Tips Quick tips for SQL tuning tips: Do not modify indexed columns with functions such as RTRIM, TO_CHAR, UPPER, TRUNC as this will prevent the […]
SQL Tips & Tricks
Reading Time: 1 minutesSQL Tips & Tricks SQL Tips & Tricks Below are few details which will add value to your SQL knowledge. Count(*) vs Count(1) COUNT(SomeColumn) will only return the count of […]
Run Unix Process in Background
Reading Time: 1 minutesRun Unix Process in Background Run Unix Process in Background Sometimes during running jobs or commands which needs long time and you will want to run the command and "exit" […]
Unix Tips & Tricks
Reading Time: 1 minutesUnix Tips & Tricks Unix Tips & Tricks Below are some quick tips for UNIX which can help in daily tasks: $ !-n where n is any integer will run […]
Python: String formatting in Python
Reading Time: 1 minutes!!!Under Construction!!!
Python: Decorators
Reading Time: 1 minutesPython Decorators Python Decorators Decorators is a Python-exclusive feature, virtue of which you can define a function called a decorator function. This decorator function takes an object, manipulates it using […]
Python: Different Types of Arguments
Reading Time: 1 minutesTypes of Arguments in Python Functions Types of Arguments in Python Functions Arguments in Python functions are of three types: Positional Arguments Keyword Arguments Variable Length Arguments Positional Arguments The […]
Python: Comprehensions
Reading Time: 3 minutesPython Comprehensions Python Comprehensions Table of Contents List Comprehensions Using the if keyword inside a Comprehension Set Comprehensions Dictionary Comprehensions Comprehending Comprehensions with more than 1 for loop Generator Expressions […]
Python: Using builtin constructors map(), filter(), reduce()
Reading Time: 4 minutesmap, filter, reduce in Python map, filter, reduce in Python map() It is fairly common in programming to iterate over an iterable object, send each element to a function which […]