Skip to content

Home
About Me
Toggle search form
Search for:

Transfer SQL Profiles from One database to other database. Oracle
Find_stale_dr.sql finding stale physical DR.. Oracle
checking redhat linux version Linux/Unix
Create type and Grant on it. Oracle
Find Stale DR Physical Standby Oracle
v$backup.status information Oracle
Oracle 11g RAC on OEL 5 and Vmware 2 Oracle
Oracle Release Explaination Oracle
replace alphabets using sed Linux/Unix
Sequence Resetting Oracle
Search and Replace vi editor command. Linux/Unix
How does one overcome the Unix 2 Gig file limit? Linux/Unix
create database link syntax Oracle
Adding Datafile on Primary Server and Impact on Standby Server Oracle
login.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

Finding locked objects Oracle
dbinv.sql Oracle
Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
import-export with multiple files Oracle
Oracle Release Explaination Oracle
Clean up 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)
Linux/Unix (149)
MYSQL (5)
Oracle (392)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (341)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

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
T-SQL Vs PL/SQL Syntax25-Jul-2025
Check SQL Server edition25-Jul-2025
Checking SQL Server Version25-Jul-2025
Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
V$INSTANCE of Oracle in MYSQL24-Jul-2025
Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Find_table_size.sql Oracle
find_cons.sql Oracle
Flowers Resize datafiles Oracle
RAC with RHEL4 and 11g Oracle
In Addition to previous note, following grants needed on PERFSTAT user. Oracle
Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
Linux CPU info. Linux/Unix
currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme