Skip to content

Home
About Me
Toggle search form
Search for:

Kernel Parameter setting explaination for Processes Parameter Linux/Unix
Database logon trigger issue Oracle
tuning commmand for cpu, ip and memory stats Linux/Unix
Oracle GoldenGate lag monitoring shell script Linux/Unix
Oracle vs MYSQL Architecture differences (For DBAs) MYSQL
Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
Find average Row Length and other table size calculation. metalink notes Oracle
find_idle_cpu.sql Oracle
Sort with ASCII order and Numeric Order Linux/Unix
newupload.html PHP/MYSQL/Wordpress
V$transaction notes for finding XID composition. Oracle
Good link for LIO in Oracle ( Logical IOs) Oracle
pvm_metric.sql for gathering report from vmstat tables Oracle
Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
moving lob object to other tablespace lob_mvmt.sql Oracle

Index Range Scan

Posted on 01-Dec-2005 By Admin No Comments on Index Range Scan

If your index is NONUNIQUE, you cant enforce Index Unique Scan.

Oracle, SQL scripts

Post navigation

Previous Post: SQLPLUS COPY command Precautions.

Next Post: USE_NL and INDEX hints example

Related Posts

Load testing on Oracle 19C RAC with HammerDB Oracle
Free conference number from http://www.freeconference.com Oracle
v$backup.status information Oracle
Good links for x$ tables in oracle. Oracle
ORACLE_SID in sqlplus Oracle
SYSOPER Mystery Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Categories

Ansible (0)
AWS (2)
Azure (1)
Django (0)
GIT (1)
Linux/Unix (149)
MYSQL (5)
Oracle (397)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (150)
SQL scripts (345)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

track_autoupgrade_copy_progress.sql01-Apr-2026
refre.sql for multitenant01-Apr-2026
prepfiles.sh for step by step generating pending statistics files10-Mar-2026
tracksqltime.sql05-Mar-2026
Complete Git Tutorial for Beginners25-Dec-2025
Postgres DB user and OS user.25-Dec-2025
Trace a SQL session from another session using ORADEBUG30-Sep-2025
SQL Server Vs Oracle Architecture difference25-Jul-2025
SQL Server: How to see historical transactions25-Jul-2025
SQL Server: How to see current transactions or requests25-Jul-2025

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

pvm_rbs1.sql (to collect rbs info from db) Oracle
How to choose Driver table in SQL statement Oracle
find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
Oracle Statspack survival Guide Oracle
tab.sql Oracle
oracle fast start failover best practice Oracle
Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme