Not to stick this topic strictly:
Is there any possibility, that I have created view on a table with some 'where' condition, and it slows SPs so much, with the original table, and where clauese I get some 10 secs, but with view, with the same clauses (of course without the table filtering) I got 2-3 minutes, or maybe 10-20 minutes. Can I do aníthing with this?

----- Original Message -----
From: Lester Caine
To: firebird-support@yahoogroups.com
Sent: Tuesday, August 23, 2005 10:35 AM
Subject: Re: [firebird-support] Rename table


Bc. Jiri Cincura wrote:

> Martijn Tonies wrote (on Tuesday, August 23, 2005 9:57 AM):
>
>>>Bc. Jiri Cincura wrote (on Monday, August 22, 2005 7:47 PM):
>>>
>>>>Hi,
>>>>
>>>>is there any option how to rename table?
>>>
>>>Nobody knows? :\
>>
>>Sure, the only thing you can do is extract the DDL, rename the table
>>and recreate the table. Next, pump the data.
>>
>>There's no built-in "rename" functionality.
>
>
> It's not good. :( The table is about too big to do this.
>
> So it must stay as is.

Why do you need to change the name ?
How about just adding a view with the new name ?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links







[Non-text portions of this message have been removed]