You have two options: - Modify your primary key to include metric_type & timestamp as leading columns. - Create an index on metric_type & timestamp
On Monday, October 3, 2016, Kanagha <[email protected]> wrote: > Sorry for the confusion. > > metric_type, > timestamp, > metricId is defined as the primary key via Phoenix for metric_table. > > Thanks > > Kanagha > > On Mon, Oct 3, 2016 at 3:41 PM, Michael McAllister < > [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> > >> >> there is no indexing available on this table yet. >> >> > >> >> >> >> So you haven’t defined a primary key constraint? Can you share your table >> creation DDL? >> >> >> >> Michael McAllister >> >> Staff Data Warehouse Engineer | Decision Systems >> >> [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');> | C: >> 512.423.7447 | skype: michael.mcallister.ha >> <javascript:_e(%7B%7D,'cvml','[email protected]');> | webex: >> https://h.a/mikewebex >> >> This electronic communication (including any attachment) is >> confidential. If you are not an intended recipient of this communication, >> please be advised that any disclosure, dissemination, distribution, copying >> or other use of this communication or any attachment is strictly >> prohibited. If you have received this communication in error, please >> notify the sender immediately by reply e-mail and promptly destroy all >> electronic and printed copies of this communication and any attachment. >> >> >> >> *From: *Kanagha <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> >> *Reply-To: *"[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>" < >> [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> >> *Date: *Monday, October 3, 2016 at 5:32 PM >> *To: *"[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>" < >> [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>>, " >> [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>" < >> [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> >> *Subject: *Re: Question regarding designing row keys >> >> >> >> there is no indexing available on this table yet. >> > >
