Hey, what I am saying is that there could not be a correct index on a certain table.
The following tables have no indexes : dbo.dtproperties dbo.extendeddata dbo.logreports dbo.pathreports dbo.plpprototypes dbo.sessionreports all the rest have indexes of varying degree (both clustered and non-clustered). They may not also be on the fields you expect. The objects table has a clustered index on objectid but nonclustered on objectid & label. I can certainly go ahead and check others for you, but I bet the non-index calls are all from actions from within the Webtop! HTH Neil p.s. You could of course create your own indexes based on your performance reviews, ideally the CODB should have been normalized (well, as far as an Object-Based DB can be!) with proper indexes. -----Original Message----- From: Mathijs dew [mailto:mathijsdew@;yahoo.com] Sent: 23 October 2002 11:56 To: Spectra-Talk Subject: RE: Spectra/Oracle issue: high non-index lookup ratio on codb Neil, I am not sure if i am understanding what you are saying.... but i will give it a try. We use cfa_contentobjectget and getmultiple... to retrieve content.... this all comes out of the objects table i would expect.... would it be wrong for me to assume that there should be a index on this table by default...? . but please... tell me if i am saying something stupid now... Mathijs "Robertson-Ravo, Neil (REC)" <[EMAIL PROTECTED]> wrote:I think you will find that there are a lot of calls for objects and types not performed on an index...! So you know what tables are affectted? -----Original Message----- From: Mathijs dew [mailto:mathijsdew@;yahoo.com] Sent: 23 October 2002 11:44 To: Spectra-Talk Subject: Spectra/Oracle issue: high non-index lookup ratio on codb Hi, I have a .. uhmmm... let's call it a bit of a weird question. Okay here's the case: We have a large public website running using Spectra 1.5.1 using a Oracle 8.1.7 Enterprise database (runnin on a largescaled AIX environment). The spectra site runs on a highend compaq dlt380, 1 GB of ram. The problem: >From the dba's who maintain the database environment i've received the following information. They are saying the following: "We see a very high non-index lookup ratio in the application (they are talking about the codb). Could you please have a look at it." Then they have also supplied some statistics. They measured the performance during a two hour time span. consistent gets = 7440165 db block gets = 5195 physical reads = 93272 logical reads = 7445360 hit ratio = 98 table scans long = 697 table scans short = 97 non-index lookup ratio = 87 My guess would be... some bad use of indexes in the codb db's design. But what i can't do is just go in there and make some changes and so... because i am not sure about the things that can go wrong. So my question would be if somebody out there experienced the same problem... and how did they go about handling this. Kind regards. Mathijs --------------------------------- Do you Yahoo!? Y! Web Hosting - Let the expert host your web site ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
