|
Home > Archive > MS SQLCE > March 2006 > Combindex Indexes Date + String
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Combindex Indexes Date + String
|
|
| info@it-design.biz 2006-03-09, 7:25 am |
| Hi
In my application I created an index with an Date and an String field,
because the most accesses in this tables have an where clause
concerning these two fields?
How may I use these indexes in an SQL Select ?
The Database used ist SQL Mobile 3.0
| |
| Darren Shaffer 2006-03-10, 11:24 am |
| the SQL Mobile Query Processor will consider all indexes on the table
and choose one and only one to include in the execution plan. if you
cannot tell that the index you have added is being used (simply by a
notable improvement in query performance), the way to handle this is
to view the execution plan that the QP is selecting for your query. This
can be done in SQL Server 2005 Management Studio (when connected
to your SQL Mobile database), and from Query Analyzer 3.0 (will save
the execution plan as XML and you then need to load it into SS2005MS)
The SQL Mobile Books OnLine contain information about viewing
query execution plans.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
<info@it-design.biz> wrote in message
news:1141897406.713721.275180@i39g2000cwa.googlegroups.com...
> Hi
>
> In my application I created an index with an Date and an String field,
> because the most accesses in this tables have an where clause
> concerning these two fields?
>
> How may I use these indexes in an SQL Select ?
> The Database used ist SQL Mobile 3.0
>
| |
| info@it-design.biz 2006-03-13, 3:23 am |
| Thanks for help! I'll check it
|
|
|
|
|