Hi,
I haven't tested with nightlies, sorry if this is bogus:
Using a MySQL connection.
Linq that fails:
var clients = (from client in JisRepository.FindAll<Integration.Jis.Client>()
orderby client.Cliname ascending
group client by client.Cliname.First() into groupedByFirstLetter
select new ClientListItemViewModel()
{
FirstLetter = groupedByFirstLetter.Key
}).ToList();
Exception:
The method 'First' is not supported.
at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractMethodCriteria(LinqQueryPlanExpression plan, MethodCallExpression expression)
at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(LinqQueryPlanExpression plan, Expression expression)
at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(LinqQueryPlanExpression plan, Expression expression)
at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(LinqQueryPlanExpression plan, Expression expression)
at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(LinqQueryPlanExpression plan, Expression expression)
at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(LinqQueryPlanExpression plan, Expression expression)
at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(LinqQueryPlanExpression plan, Expression expression)
at Mindscape.LightSpeed.Linq.Sqo.GroupBy.HandleSingleGrouping(LinqQueryPlanExpression subplan, Expression expression)
at Mindscape.LightSpeed.Linq.Sqo.GroupBy.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression)
at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp)
at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp)
at Mindscape.LightSpeed.Linq.Sqo.Select.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression)
at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp)
at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp)
at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Build(Expression translation, LinqQueryProvider provider)
at Mindscape.LightSpeed.Linq.LinqQueryProvider.GetExecutionPlan(Expression expression)
at Mindscape.LightSpeed.Linq.LinqQueryProvider.Execute(Expression expression)
at Mindscape.LightSpeed.Linq.LinqQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression)
at Mindscape.LightSpeed.Linq.LinqQuery1.GetEnumerator()
at System.Collections.Generic.List
1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable
1 source)
Linq that works:
var clients = (from client in JisRepository.FindAll<Integration.Jis.Client>()
orderby client.Cliname ascending
group client by client.Cliname.Substring(0, 1) into groupedByFirstLetter
select new ClientListItemViewModel()
{
FirstLetter = groupedByFirstLetter.Key[0]
}).ToList();
The SQL from the working LINQ:
SELECT
g1.clientdb.Cliname_SUBSTRING
FROM
(
SELECT
SUBSTRING(clientdb
.Cliname
, 1, 1) AS "clientdb.Cliname_SUBSTRING"
FROM
clientdb
clientdb
GROUP BY
SUBSTRING(clientdb
.Cliname
, 1, 1)
)
g1
--> Time: 25 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'A'
ORDER BY
clientdb
.Cliname
--> Time: 21 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'B'
ORDER BY
clientdb
.Cliname
--> Time: 18 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'C'
ORDER BY
clientdb
.Cliname
--> Time: 17 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'D'
ORDER BY
clientdb
.Cliname
--> Time: 14 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'E'
ORDER BY
clientdb
.Cliname
--> Time: 18 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'F'
ORDER BY
clientdb
.Cliname
--> Time: 20 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'H'
ORDER BY
clientdb
.Cliname
--> Time: 15 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'I'
ORDER BY
clientdb
.Cliname
--> Time: 17 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'J'
ORDER BY
clientdb
.Cliname
--> Time: 18 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'K'
ORDER BY
clientdb
.Cliname
--> Time: 13 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'L'
ORDER BY
clientdb
.Cliname
--> Time: 25 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'M'
ORDER BY
clientdb
.Cliname
--> Time: 23 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'N'
ORDER BY
clientdb
.Cliname
--> Time: 17 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'O'
ORDER BY
clientdb
.Cliname
--> Time: 22 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'P'
ORDER BY
clientdb
.Cliname
--> Time: 15 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'R'
ORDER BY
clientdb
.Cliname
--> Time: 13 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'S'
ORDER BY
clientdb
.Cliname
--> Time: 20 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'T'
ORDER BY
clientdb
.Cliname
--> Time: 15 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'V'
ORDER BY
clientdb
.Cliname
--> Time: 18 ms
SELECT
clientdb
.cliid
AS "clientdb.cliid",
clientdb
.Cliattention
AS "clientdb.Cliattention",
clientdb
.Clicity
AS "clientdb.Clicity",
clientdb
.Clifax
AS "clientdb.Clifax",
clientdb
.Cliname
AS "clientdb.Cliname",
clientdb
.Clinational
AS "clientdb.Clinational",
clientdb
.Cliproduct
AS "clientdb.Cliproduct",
clientdb
.Clishort
AS "clientdb.Clishort",
clientdb
.Clistartdate
AS "clientdb.Clistartdate",
clientdb
.Clistate
AS "clientdb.Clistate",
clientdb
.Clistatus
AS "clientdb.Clistatus",
clientdb
.Clistreet
AS "clientdb.Clistreet",
clientdb
.Clitel
AS "clientdb.Clitel",
clientdb
.Clitrapri
AS "clientdb.Clitrapri",
clientdb
.Clizip
AS "clientdb.Clizip"
FROM
clientdb
WHERE
SUBSTRING(clientdb
.Cliname
, 1, 1) = 'Y'
ORDER BY
clientdb
.Cliname
--> Time: 17 ms
Conclusion:
Room for improvement? ;-)
Thanks!
Dennis