Connor McDonald wrote:
> Oradba Linux wrote:
>
>>http://asktom.oracle.com/pls/ask/f?p=4950:8:13189451231851900629::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1562813956388
>>
>>I have reading through this link and it made me curious to find out if there
>>are sites out there having your own version of dual
>>instead of sys.dual.
>
>
> It can be useful for applications where you can't change the code - we
> had an app where a myriad of things did a 'select .. from dual' (even
> to be basic assignments to variables). The options we had were:
>
> a) shoot the vendor (my preference)
> b) have a local version of dual in the relevant schemas
>
> Be careful - you'll be amazed what it can affect. We tried an IOT local
> version of dual, and suddenly our fast-refresh-single-table-aggregate
> materialised views stopped working...!!! We compromised with a heap
> (local) dual with an index on it.
>
> hth
> connor
>
...but dual only ever has one row in it. Why index?
Steve
Received on Sun Jan 09 2005 - 11:15:01 CST
