avoiding indexes on queries

krishhhna

13 New Member

hi,
how can i avoid using indexes on my queries

Oct 3 '07 #1

Subscribe Reply

1174

debasisdas

8,127

Recognized Expert Expert

Indexes are created to be used in queries to increase the performance of queries. If u dont want to use ,they why you created all those indexes.

Oct 3 '07 #2

gintsp

New Member

Indexes are created to be used in queries to increase the performance of queries. If u dont want to use ,they why you created all those indexes.

MM sometimes full scan of a table is better access path than index scan-table scan. Also there are obligatory indexes for Primary/Unique keys and very strongly advised indexes on Foreign keys :)

OK to the OP question is - are you really sure that using indexes is your problem?
Then you can try hint all_rows or the same optimizer_mode. It informs Oracle that you need get back all the data as fast as possible and not only the first row as fast as possible.
Another option is to try FULL or NO_INDEX hints. However I suggest you use hints as a last resort only.
For all hints see Oracle docs:
http://download.oracle.com/docs/cd/B...lements006.htm

Gints Plivna

http://www.gplivna.eu

Oct 4 '07 #3

Similar topics

2244

Don't use clustered indexes?

by: Steve_CA | last post by:

Hi, The more I read, the more confused I'm getting ! (no wonder they say ignorance is bliss) I just got back from the bookstore and was flipping through some SQL Server Administration...

Microsoft SQL Server

1673

Do I need keys/indexes for a 3column table?

by: Randell D. | last post by:

Folks, My internet access is intermitent until I get my own connection inside the next ten days - I say this so that I can thank in advance who ever gives a few seconds to read/answer my...

MySQL Database

1803

table update with or without indexes enabled?? 390/V7

by: robert | last post by:

my colleagues are convinced that having more than an index or two destroys performance on their batch runs. could be. i don't have the data, and i'm wondering whether there might be some...

DB2 Database

1682

How I can get statistics by indexes using?

by: bughunter | last post by:

For example - very large table with a lot indexes and updates work very slow. I'd like found unused or rarely used indexes. How? Yes, for static I found all sql in packages and, after analyse,...

DB2 Database

3577

Avoiding sequential scans with OR join condition

by: Mike Mascari | last post by:

Hello. I have a query like: SELECT big_table.* FROM little_table, big_table WHERE little_table.x = 10 AND little_table.y IN (big_table.y1, big_table.y2); I have indexes on both big_table.y1...

PostgreSQL Database

1495

Indexes

by: Shiraz | last post by:

Is there some manual on how to make indexes? for example: table is create mytable ( a varchar, b varchar, c int, d int

MySQL Database

2588

Indexes and views

by: umair.cheema | last post by:

Hi! 1-I read in MS Access help that Indexes are automatically made when we declare a primary key and they are used for fast searching and sorting purpose. But i am still confused that how can i...

Microsoft Access / VBA

1747

Indexes on SQL Server 7.0

by: Zamdrist | last post by:

I am tasked with maintaining a large database still on SQL Server 7.0. Performance is an issue not surprisingly and I've targeted two rather large tables to see what I can do with the indexes. ...

Microsoft SQL Server

3016

Default Indexes on TransferText Method?

by: Greg Strong | last post by:

Hello All, Why does Access (2003) create indexes on importing a CSV file to a table when using the TransferText Method in VB when the specification name does NOT have any indexes indicated? ...

Microsoft Access / VBA

6905

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

6736

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5331

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4772

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

2994

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

2980

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1299

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

561

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

178

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General