Excellent !!!!



----- Original Message -----
From: "Ganhão, Luís Manuel Martins, VF-PT " <oracledba-ezmlmshield-x77285437.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: Select Count(*) slower
Date: Tue, 31 May 2005 12:29:23 +0100

>
>
> Ok...
>
>
> let's see who can imagine the dummiest solution...
>
>
> I start..
>
>
> Yesterday select count(*) from <table> was faster because...
>
>
> <table> it's a synonym... and synonym changed from a small table to
> a huge table :-)
>
>
> Hope to see other dummy solutions :-)
>
>
> Regards,
>
>
> LG
>
>
> ------------------------------------------
> This message may contain confidential information or privileged material,
> and is intended only for the individual(s) named. If you are not in the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
>
> E-mail transmission cannot be guaranteed to be secure or error-free as
> information could be intercepted, corrupted, lost, destroyed, arrive late
> or incomplete, or contain viruses. The sender therefore does not accept
> liability for any errors or omissions in the contents of this message
> which arise as a result of e-mail transmission. If verification is
> required please request a hard-copy version.
>
> Vodafone (Portugal)
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page