Hi
The query is not optimized as it is scanning 45048 rows.
Vertical partitioning can be used because there is a lot of column in single
table.
On Tue, May 6, 2008 at 3:26 PM, Michael Stearne <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> The main table for our site is called properties and it gets hit qui
As a note. The query itself may not be taking long but there are many
"Sorting result " and "Copying to tmp table " in myTop.
Thanks,
Michael
On Tue, May 6, 2008 at 3:26 PM, Michael Stearne <[EMAIL PROTECTED]> wrote:
> Hi.
>
> The main table for our site is called properties and it gets hit q
