I have a sql statement that joins to 4 tables with inner join
and at the last I have where clause. When I execute the statements it runs
the inner join and then applies the where clause on the results.
Do you mean this on logical or physical level?
Is this normal?
Logically, ANSI standard defines that SELECT statement should start
execution with FROM clause, including joins. So this is normal. Physically,
the execution plan is up to RDBMS vendor, as long as it produces logically
correct results. SQL Server usually starts with WHERE clause to eliminate as
many rows as possible right from the beginning of execution and this make
the executuon faster. however, details how the query optimizer works might
change from query to query. if you are talking about physical plan, it can
still be completely normal.
Re: reordering in paralellism-multiprocessor machine ... As I said - no order by clause, no guarantee.... > by the server for executing a query paralelly or serially.. ... > the execution plans from the query anaylzer. ... (microsoft.public.sqlserver.server)
Re: Can inner join be done on queries? ...sub-queries 3 and 4 extract data from the same table. ... I tried the compact and repair but the inner join still returns no records. ... > Not all the works numbers in query 3 are in query 4; ... I really meant order of execution of the sub-queries. ... (microsoft.public.access.queries)
Re: Evaluating Exceptions, Try Except and Try Finally ... error occurs during execution.... statementList2 (the finally clause) is executed. ...exception is raised during execution of statementList1, ... THE IF THEN ELSE STATEMENT DOCUMENTATION IS JUST AS FUCKED:)' ... (alt.comp.lang.borland-delphi)
Help With Slow SQL Query ... The table has a clustered index on the primary key. ... The foreign key in the WHERE clause has a non-clustered, ... The execution plan shows a 100% cost on a clustered index scan against the primary key of the table, with a WHERE clause for the ... I had a similar problem with another query which was far more complex. ... (microsoft.public.sqlserver.server)
ignored words...how to configure ...Execution of a full-text operation failed. ... A clause of the query...Prev by Date: ... (microsoft.public.sqlserver.fulltext)
