SQL Server Indexes: The Ultimate GPS for Your Data Journey
We all have noticed how some SQL Server queries feel like a luxury express train, zooming to their destination, while others resemble a sluggish car through traffic jams?
Read MoreSQLTXTRACT and SQLTEXECUTE -Revealing Confusion
SQLT XTRACT is the easiest report to create because it does not require the execution of the SQL at the time of the report generation. The report can be collected…
Read MoreSGA TARGET ADVISORY IN ORACLE
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is…
Read MoreHow to Read an Execution Plan
What Is an Execution Plan? When you send a query to the database, it’s the job of the SQL optimizer to figure out how to execute it, and that process…
Read MoreStart Tuning….
How to Start tuning: Server Level (Focus from Oracle Database) Whenever there is server level issue, The tuning starts from the server .. Just remember the phrase “The person who…
Read More