We have a Siebel implementation and for one query that was taking a long
time to run I asked a DBA to evaluate the explain plan. I noticed that
he chose to evaluate the Rule based optimization. I asked him why and
he said that the Siebel application defaults to Rule based optimization.
Not that I don't trust him, but I had the impression that Cost based was
the way to go.
Is it possible to set up a database schema so that it the optimizer
always uses Rule based rather than Cost ? And if anyone knows Siebel,
is this the actual default ?
Thanks. 5 7131
"Terry Coccoli" <re*****@ifneed ed.com> wrote in message
news:Gi******** *************** @news.easynews. com... We have a Siebel implementation and for one query that was taking a long time to run I asked a DBA to evaluate the explain plan. I noticed that he chose to evaluate the Rule based optimization. I asked him why and he said that the Siebel application defaults to Rule based optimization.
Not that I don't trust him, but I had the impression that Cost based was the way to go.
Is it possible to set up a database schema so that it the optimizer always uses Rule based rather than Cost ? And if anyone knows Siebel, is this the actual default ?
Thanks.
Siebel is rule based.
They are about 5 years behind in taking advantage of the database technology
that the system runs on. Yes, cost is the way to go but not with Siebel.
They won't support you if you use rule based. (which means you can't do a
whole bunch of things) One thing that you can do to get around this is that
if you have a specific query that is better under cost based you can use a
stored outline. (get Thomas Kyte's book)
Jim
Jim Kennedy wrote: "Terry Coccoli" <re*****@ifneed ed.com> wrote in message news:Gi******** *************** @news.easynews. com...
We have a Siebel implementation and for one query that was taking a long time to run I asked a DBA to evaluate the explain plan. I noticed that he chose to evaluate the Rule based optimization. I asked him why and he said that the Siebel application defaults to Rule based optimization.
Not that I don't trust him, but I had the impression that Cost based was the way to go.
Is it possible to set up a database schema so that it the optimizer always uses Rule based rather than Cost ? And if anyone knows Siebel, is this the actual default ?
Thanks.
Siebel is rule based. They are about 5 years behind in taking advantage of the database technology that the system runs on. Yes, cost is the way to go but not with Siebel. They won't support you if you use rule based. (which means you can't do a whole bunch of things) One thing that you can do to get around this is that if you have a specific query that is better under cost based you can use a stored outline. (get Thomas Kyte's book) Jim
What happens if you throw in a hint like FIRST_ROWS? Would the
optimizer accept the hint ?
"Terry Coccoli" <re*****@ifneed ed.com> wrote in message
news:nu******** *************** @news.easynews. com... Jim Kennedy wrote: "Terry Coccoli" <re*****@ifneed ed.com> wrote in message news:Gi******** *************** @news.easynews. com...
We have a Siebel implementation and for one query that was taking a long time to run I asked a DBA to evaluate the explain plan. I noticed that he chose to evaluate the Rule based optimization. I asked him why and he said that the Siebel application defaults to Rule based optimization.
Not that I don't trust him, but I had the impression that Cost based was the way to go.
Is it possible to set up a database schema so that it the optimizer always uses Rule based rather than Cost ? And if anyone knows Siebel, is this the actual default ?
Thanks.
Siebel is rule based. They are about 5 years behind in taking advantage of the database
technology that the system runs on. Yes, cost is the way to go but not with
Siebel. They won't support you if you use rule based. (which means you can't do
a whole bunch of things) One thing that you can do to get around this is
that if you have a specific query that is better under cost based you can use
a stored outline. (get Thomas Kyte's book) Jim
What happens if you throw in a hint like FIRST_ROWS? Would the optimizer accept the hint ?
No, because it is rule based. Also you don't have access to edit the SQL
Siebel generates for the system. You can however use a logon trigger and
set up stored outlines. See Tom Kyte's book for excellent examples of how
to do this. (Expert 1 on 1 Oracle)
Jim
> What happens if you throw in a hint like FIRST_ROWS? Would the optimizer accept the hint ?
If you throw any hint to a query (except "RULE"), cost-based
optimizing is triggered. In that case, since you probably don't have
any stats for your tables, Oracle will try to make up these stats by
itself, using criteria such as number of extents used by a table (to
estimate its size), ... Oracle usually does a decent job at making up
these stats (from what I've seen), but of course it would be much
better to have real up-to-date stats if you intend to use CBO for some
queries. If you decide to go that route (use hints and gather the
stats), make sure that OPTIMIZER_MODE (for the instance running
Siebel) is RULE (and not CHOOSE), or otherwise CBO will be used for
all the queries (including the ones from the Siebel application)
running against the database, and your Siebel TAM will slap your
fingers.
Daniel Roy
IBM
Siebel/Oracle Consultant
Daniel Roy wrote: What happens if you throw in a hint like FIRST_ROWS? Would the optimizer accept the hint ?
If you throw any hint to a query (except "RULE"), cost-based optimizing is triggered. In that case, since you probably don't have any stats for your tables, Oracle will try to make up these stats by itself, using criteria such as number of extents used by a table (to estimate its size), ... Oracle usually does a decent job at making up these stats (from what I've seen), but of course it would be much better to have real up-to-date stats if you intend to use CBO for some queries. If you decide to go that route (use hints and gather the stats), make sure that OPTIMIZER_MODE (for the instance running Siebel) is RULE (and not CHOOSE), or otherwise CBO will be used for all the queries (including the ones from the Siebel application) running against the database, and your Siebel TAM will slap your fingers.
Daniel Roy IBM Siebel/Oracle Consultant
Thanks for the headsup, Roy. I think you've given me a couple of
questions that I need to discuss with the DBA. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mike |
last post by:
Related to another topic I just posted, I wanted to discuss ways to optimize
the validation of very large (>100MB) XML documents.
First, I have no idea if something like this already exists; it may even be
the typical implementation for all I know.
At any rate, it occurs to me that the set of business rules that need to be
validated against an XML document represent a limited set of nodes at any
given time (while parsing through the...
|
by: Jean-David Beyer |
last post by:
I have six hard drives (4 SCSI and 2 EIDE) on my main machine with parts
of a database on each drive. The main index is on one SCSI drive all to
itself. The main data are on the other three SCSI drives. Small relations
are on one EIDE drive, and the logfiles are on the other EIDE drive. When
running the task, below, the rest of the machine is not doing much.
I do not remember where I saw it, but somewhere I got the idea that the
number...
|
by: Steve V |
last post by:
I'm using Access 2000 to build a budgeting/tracking database.
Can I make a validation rule (using VBA) that checks the data as if
the record has already been added?
I've got 5 tables (only the necessary fields are shown here):
tblBudgetCategories
catName:Text
catTaxTrack:Yes/No
tblBudgetPeriods
|
by: Sidney Cadot |
last post by:
Hi all,
In a discussion with Tak-Shing Chan the question came up whether the
as-if rule can cover I/O functions. Basically, he maintains it can, and
I think it doesn't.
Consider two programs:
/*** a.c ***/
|
by: ron |
last post by:
I have a access based guest book. I want to create a validation rule to
block certain words or parts of a srting. How do i do this?
ie: this is a nice site. come visit my porn site at www.abc.zy
If the message contains the word porn, can I block the whole message
using a validation rule
| |
by: Snis Pilbor |
last post by:
With the "as if" rule in play, doesn't that effectively render the
"register" keyword completely useless?
Example: I make a silly compiler which creates code that goes out of
its way to take a full 10 minutes every time a "register" declared
variable is read from or written to. Besides this lag, everything else
runs as expected. Then my compiler is still C compliant, aye?
If so, then it is unwise for any programmer to ever use the...
|
by: siyoyok007 |
last post by:
Acctually i've being ask to develop a rule based system and the platform to be used is visual basic 6.0. What i want to know here is, how to implement the "Rule based" in VB. Can someone give some tips, or link that i can refer to.
|
by: Terry Coccoli |
last post by:
We have a Siebel implementation and for one query that was taking a long
time to run I asked a DBA to evaluate the explain plan. I noticed that
he chose to evaluate the Rule based optimization. I asked him why and
he said that the Siebel application defaults to Rule based optimization.
Not that I don't trust him, but I had the impression that Cost based was
the way to go.
Is it possible to set up a database schema so that it the...
|
by: MLH |
last post by:
Anyone remember if A97 append query failure would ever report
data breaking validation rule when such was not the case. I have
an old SQL statement - several years old now. I've encountered
a case in which the append fails and the reported error is validation
rule.
The table being appended to (tblClusters) has only 1 field with a
validation rule: , with Byte Field Size property
setting. The validation rule is >0. The field's default...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |