Re: views

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 04/20/04 

Date: Mon, 19 Apr 2004 22:55:44 -0700

Thanks hari...I need to convince my client on this..also
what are indexed views....is it equivalent to materilaized
views in oracle.
>-----Original Message-----
>Hi,
>Hi,
>
>No, the queries will use indexes if the views-- Base
table have the
>necessory indexes in place.
>
>Thanks
>Hari
>MCDBA
>
>
>"sridhar" <anonymous@discussions.microsoft.com> wrote in
message
>news:158f01c42697$9e087c90$a401280a@phx.gbl...
>> in SQL2000, database views will not inherit the indexes
>> of their underlying tables. So queries using indexes
will
>> be slow. is it true?
>
>
>.
>

Relevant Pages

  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... On the premise instant client and also tried to run perl Makefile.PL -V ... the status after having connected to Oracle ... Failed 2/33 tests, 93.94% okay ...
    (perl.dbi.users)
  • Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch wont install
    ... Currently all my Oracle inst client files are user oracle group oinstall yet lib bin and other dirs have 755 permission so root should be able to access and execute these softlibs. ... As I have written, I have installed DBD::Oracle-1.19 many times with a full client without problem, yet with the limited instant client it does not find the mk file, and the one mk file that the instant client installs does not work. ... It also gives me a makefile for DBD::Oracle but install and test fail ...
    (perl.dbi.users)
  • Re: ORATCL help needed!
    ... set cursor ... Wow, An Oratcl 3.3. ... It is coded with the the OCI layer released with Oracle ... Oracle instant client is available for many many platforms, ...
    (comp.lang.tcl)
  • Re: ORATCL help needed!
    ... set cursor ... It is coded with the the OCI layer released with Oracle ... Oracle instant client is available for many many platforms, ... Did you compile Oratcl 3.3 for yourself. ...
    (comp.lang.tcl)
  • Re: DBD::Oracle / Instant Client segfaults
    ... I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. ... When i run the script with the 'use Digest::SHA1;' line commented ...
    (perl.dbi.users)