NNP NAHAR BLOG

This blog is a note for self learning. Some writings are done by myself and some are collected, just to keep things in a organized way.

3.05.2015

Performance Tunning

1. Common Performance Issues
2. SQL Tunning or Query Optimization Tips
3. Indexing for better Performance
4. Finding Full table scan 
5. Finding outdated statistics
Labels: Performance Tunning
Newer Post Older Post Home
View NNP Nahar's profile on LinkedIn
  • AWR
  • Basic
  • Big Data
  • CLOB
  • Control File
  • Database Design
  • Datafile
  • Datapump
  • DBA scripts
  • DBA Training
  • Developer's Zone
  • Encryption
  • Error
  • FAQ - Database
  • FAQ - Oracle
  • FAQ - SQL Server
  • Function/Procedure
  • Index
  • Join
  • Linux
  • Load
  • Lock
  • Logminer utility
  • MySQL
  • Notes
  • OEM
  • Oracle Architecture
  • Partition
  • Performance Tunning
  • PL/SQL
  • SQL
  • SQL Server
  • Tablespace
  • Tools
  • Tunning (SQL)
  • View
  • ওরাকল ডাটাবেস

Archive

  • ▼  2015 (34)
    • ►  September (2)
    • ►  August (1)
    • ▼  March (13)
      • Join Methods
      • SemiJoin & AntiJoin
      • Outer Join
      • Inner Join
      • JOIN
      • TDE
      • INDEXES IN SQL SERVER
      • Frequently Asked Questions about Index
      • Bitmap Index
      • How B-tree Index works in Oracle?
      • Performance Tunning
      • Explain ROWID Vs ROWNUM?
      • Indexing for better Performance
    • ►  February (17)
    • ►  January (1)
  • ►  2013 (1)
    • ►  January (1)
  • ►  2012 (2)
    • ►  July (1)
    • ►  January (1)
  • ►  2011 (3)
    • ►  August (1)
    • ►  May (1)
    • ►  March (1)
  • ►  2010 (38)
    • ►  October (12)
    • ►  September (12)
    • ►  August (3)
    • ►  July (10)
    • ►  June (1)
  • ►  2009 (22)
    • ►  November (4)
    • ►  October (6)
    • ►  September (1)
    • ►  August (1)
    • ►  June (7)
    • ►  February (3)
  • ►  2008 (56)
    • ►  November (4)
    • ►  October (15)
    • ►  September (13)
    • ►  August (3)
    • ►  July (14)
    • ►  June (7)

Total Pageviews

Blog List

  • Oracle Scratchpad
    Pagination Cost – 2
    4 weeks ago
  • Beautiful Bangladesh
    আরবীয় বিরিয়ানি - KABSA (কাব্সা)
    10 years ago
  • Taaj
    10 years ago
  • Hasan
    TDE Part-2: Implement TDE Tablespace Encryption
    11 years ago
  • Tom Kyte Blog
    Upcoming Events...
    11 years ago
Simple theme. Powered by Blogger.