Skip to content

Home
About Me
Toggle search form
Search for:

Unix command for system configuration Linux/Unix
ORA-8031 issue and solution if it is occuring due to truncate. Oracle
on IBM-AIX for display Linux/Unix
adding new line after specific pattern using sed Linux/Unix
avail.sh ( find filesystem spae usage) Linux/Unix
Unix split command to split files Linux/Unix
tracksqltime.sql Oracle
Pending Distributed Transations Oracle
to see when crontab is changed. Linux/Unix
Which environment is used by currently running process ( Very good) Linux/Unix
find_idle_cpu.sql Oracle
send attachment from unix-shell script Linux/Unix
SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
checking connectivity between two servers Linux/Unix
Display the top 5 salaries for each department using single 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

How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
How to set Processes Parameter Oracle
Proc Compilation Oracle
arch_configUOCIOTTO.ora Oracle
Updated LCK.SQL file. 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 (402)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (350)
SQL Server (6)
Uncategorized (3)
Videos (0)

Recent Posts

runon_allpdbs_show_conname.sh23-Apr-2026
runon_allcdbs_find_pdbs.sql23-Apr-2026
Running PDB on single node in RAC09-Apr-2026
find_arc.sql09-Apr-2026
pvm_pre_change.sql08-Apr-2026
find_encr_wallet.sql08-Apr-2026
find_pdbs.sql08-Apr-2026
Creating a Container Database using dbaascli08-Apr-2026
track_autoupgrade_copy_progress.sql01-Apr-2026
refre.sql for multitenant01-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

CPU Core related projections AWS
Find sort details from Db find_sort.sql Oracle
find_log_switch.sql Find log switches in graphical manner Oracle
Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
Gathering statistics with DBMS_STATS Oracle
process id based files and processes Linux/Unix
CTAS with LONG Column for 7.x and 8 and 8i Oracle
Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme