Speed up SQL

[Beatrix Willius]

Yes, in VStudio.

  FOUND in the QueryPool: NO
  FOR SQL QUERY TIME = 929 :
  DO SELECT : TIME = 929 : ROWS = 2
  DO SIMPLE SELECT : TIME = 929 : ROWS = 2
  DO Build JoinTable : TIME = 3 : ROWS = 9519
  DO For each Table from 2 resolve its WHERE conditions that we can do before Joins : TIME = 0 :
  FOR Table [Message]  DO SelectAllRecords : TIME = 0 : ROWS = 9519
  FOR Table [Mailbox]  DO SelectAllRecords : TIME = 0 : ROWS = 11
  DO Joins : TIME = 3 : ROWS = 9519
  DO [Mailbox] INNER JOIN [Message] ON [Link_1](Sort Merge) : TIME = 2 : ROWS = 9519
  FOR Table [tmp_table_17]  DO resolve WHERE statement : TIME = 414 : ROWS = 2
  FOR Predicate [OR] TIME = 17 : ROWS = 2
  DO OR Non-Indexed operands : TIME = 17 : ROWS = 2
  FOR Field [From]  DO FindRegEx : TIME = 12 : ROWS = 1
  FOR Field [To]  DO FindRegEx : TIME = 1 : ROWS = 0
  FOR Field [Subject]  DO FindRegEx : TIME = 3 : ROWS = 0
  FOR EXPR  DO Scan of column : TIME = 0 : ROWS = 1
  FOR EXPR  DO Scan of column : TIME = 0 : ROWS = 0
  FOR EXPR  DO Scan of column : TIME = 1 : ROWS = 0
  FOR EXPR  DO Scan of column : TIME = 0 : ROWS = 0
  DO ORDER BY : TIME = 2 : ROWS = 2
  DO Cursor Creation : TIME = 0 :
  DO Record Locks : TIME = 0 :

Sometimes I despair over you guys:

- "Tunes" reminds me of iTunes. What about "Query data" or something like this?
- It was only possible to copy this data line by line. Please...

On 08.01.2012, at 19:03, Ruslan Zasukhin wrote:

> In vstudio?
> 
> And what shows Tune panel after this query ?
> Please copy paste it here

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals