473,320 Members | 1,987 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Oracle 7, Indexes

Dear reader,

My software supplier does not allow me to create an index on "their" tables.
Their point is that it can have a bad influence on the performance of
"their" forms, queries, things and so on.
However, for some reason, I need to make an index on certain columns in one
of "their" tables. At least, I want to search on certain columns that are
not indexed.
One option is to copy the relevant part of the table to a table of my own an
create an index. But, that costs a lot of space, data can be old, you have
to refresh etc.
By the way, running on Oracle 7, next year that will be 8.

I hope their is some way of making an index invisible to other users or
something like that.

Does anyone have an suggestion ?

Thanks in advance!

Kind regards,
Freek

A certain part of my email adres needs to be removed incl the _
Jul 19 '05 #1
1 2371
1) no indexes are invisible, you can't hide them from the object's owner
2) it's not clear in your post if you realize that you don't need an index
on a column in order to search for a value in that column -- the index is
only necessary for uniqueness (not the case here) or potentially for
performance improvement
3) if there is no way physically or politically that you can create an
index, you need to balance the benefits of an index (which would require in
this case, cloning the table and creating the index) with the cost of
maintaining a the additional table and index(es) -- if you run reports
often, and it's ok for the data to be somewhat out of date, then it may be
worth the processing cost to create the other table -- however, it sounds
like it's probably not going to be worth the effort.
4) if your analysis under #3 indicates the index is valuable, you need to
present your case to your vendor -- a reasonable vendor should be willing to
discuss stuff like this -- however, if they're still running on Oracle 7,
their Oracle savvy and reasonableness is a bit suspect

-- mcs

"Freek" <in****************@xs4all.nl> wrote in message
news:3f***********************@news.xs4all.nl...
Dear reader,

My software supplier does not allow me to create an index on "their" tables. Their point is that it can have a bad influence on the performance of
"their" forms, queries, things and so on.
However, for some reason, I need to make an index on certain columns in one of "their" tables. At least, I want to search on certain columns that are
not indexed.
One option is to copy the relevant part of the table to a table of my own an create an index. But, that costs a lot of space, data can be old, you have
to refresh etc.
By the way, running on Oracle 7, next year that will be 8.

I hope their is some way of making an index invisible to other users or
something like that.

Does anyone have an suggestion ?

Thanks in advance!

Kind regards,
Freek

A certain part of my email adres needs to be removed incl the _

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: michael newport | last post by:
Dear friends of database(s), After 13 years of Ingres, I am now using Oracle. But is Oracle technically better than Ingres. I would be much obliged if anyone could shed some light on the...
14
by: Ruth | last post by:
Hi All I am not a DBA, but a unix administrator. After our DBA's upgraded from oracle 8.0.5 to oracle 8.1.7.4 on our test server, we have noticed a big slow down in our application...
125
by: Rhino | last post by:
One of my friends, Scott, is a consultant who doesn't currently have newsgroup access so I am asking these questions for him. I'll be telling him how to monitor the answers via Google Newsgroup...
3
by: premmehrotra | last post by:
I am using Access 2000 and Oracle 9.2.0.x on a Windows 2000. I have setup Oracle 9.2 ODBC Driver (I have not yet figured how to set Microsoft's Oracle ODBC driver). I am exporting a table from...
42
by: Paul | last post by:
Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse...
56
by: Ashish Patankar | last post by:
I want to migrate my Oracle 10g database to Db2. I want some documentation for the comparision between these to databases. I also want to know which features of Oracle 10g are supported by Db2 and...
11
by: funky | last post by:
hello, I've got a big problem ad i'm not able to resolve it. We have a server running oracle 10g version 10.1.0. We usually use access as front end and connect database tables for data extraction....
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
1
by: thupham | last post by:
Hi all, For converting Oracle to SQL, I convert a table and all index in that table, but in SQL, if we have 4 columns, we can only create maximum 3 indexes, in Oracle is not, if we have 4...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.